"AN" Enterprise Solution 2

<

AlNik Solutions© PMPlan© Enterprise Software Tools For Project Management, and "Designed for Project Managers by Project Managers" Aligned with the Principles of the ANSI/EIA-748-A-1998 Standard for Earned Value Management (EVM)

LMPlanDB/System Installation LMPlanDB, a component of PMPlan Enterprise for Earned Value Management (EVM) LMPlanDB, a complementary module to PMPlanDB, is a powerful management software tool for project and organizational workload, and human resource manloading and forecasting. LMPlanDB uses the same resource pool and resource tree as the PMPlanDB application, but uses different project and loading tables. This module is configured for the line manager that views the resource loading on a monthly basis at the billable project level and for un-billable overhead activities. This provides a quicker means of looking across all projects and site forecasts. The project data from PMPlanDB and PMPlanPro can be imported into the LMPlanDB tables. LMPlanDB stores its data in the 'PMPlanDatabase' that contains all of the tables used by both PMPlanDB and PMPlanPro. The 'PMPlanDatabase' is attached to an independently purchased and installed Microsoft SQL Server 2000™ on the organization's network server, and is managed by anDBManager. Recommended system requirements for the use of PMPlan Enterprise products: Windows 2000/XP recommended 128MB RAM recommended but may require more for a large project plan 200 MB free hard disk space 1024 x 768 display recommended, 256 colors minimum Microsoft SQL Server™ PMPlan Enterprize products (PMPlanDB©, anDBManager© and LMPlanBD©) require a database interface to an organizational network installation of Microsoft's SQL Server 2000™, or a later version, in order to function for multiuser requirements. The organizations IT professional may need to be consulted to coordinate the use of, and/or the installation the MS SQL Server™, as well as the installation and maintenance of PMPlanDB, anDBManager, LMPlanDB, and the associated 'PMPlanDatabase'. Information for the use and purchase of MS SQL Server™ may be obtained at: http://www.microsoft.com/sql/prodinfo/default.mspx   First, Install anDBManager and the 'PMPlanDatabase' Run 'InstallanDBManager.exe' to install anBManager.exe Installing the database Copy Database files to SQL Server Machine Copy the following two files from the anDBManager installation directory into C:\Program Files\Microsoft SQL Server\MSSQL\Data PMPlanDatabase.mdf PMPlanDatabase_log.ldf Attach Database to SQL Server Select Start | All Programs | Microsoft SQL Server | Enterprise Manager Click on + next to Microsoft SQL Servers Click on + next to SQL Server Group Click on + next to (local)(Windows NT) Right Click on 'Databases' Select 'All Tasks' Select 'Attach Database …' Browse to where you have PMPlanDatabase.mdf Select 'OK' You should get 'Attaching Database has completed successfully' Close 'Enterprise Manager To attach the database to SQL Server The attached 'PMPlanDatabase' Setup ODBC Data Source Select 'Start | Administrative Tools | Data Sources (ODBC)' Click the 'System DSN' Tab Click 'Add' Select 'SQL Server' Click 'Finish' Enter PMPlan in the 'Name:' field Enter PMPlan in the 'Description:' field Enter name for Server (See SQL Server Administrator for correct name) Click 'Next' Click 'Next' Select option 'Change the default database to:' Select 'PMPlanDatabase' from combo list Click 'Next' Click 'Finish' Click 'Test Data Source' for verify that you can connect Click three 'OK's The PMPlan ODBC Data Source After Installing anDBManager and the 'PMPlanDatabase', Install LMPlanDB Run 'InstallLMPlanDB.exe' to install LMPlanDB.exe The default view of LMPlanDB - Select here to view the Guide to Using LMPlanDB!