ECMPS Support

Steps to be taken by the Database Administrator (DBA):

1. Follow these steps exactly. If you encounter any problems, immediately contact technical support.
   
   
2. Verify that you have SQL Server Native Client installed.
   
   
3. Run the following script to create the ECMPS Client Tool database on the shared network Microsoft SQL Server 2005/2008 database:
   
   ECMPS Install Script for SQL Server 2005/2008
   
   
4. Install Microsoft .Net 3.5 Framework on each workstation that will connect to the shared network ECMPS Client Tool database server.
   
   Download Microsoft .Net 3.5 Framework
   
   
5. Install the Client Tool software on each workstation that will connect to the shared network ECMPS Client Tool database server. At the end of each installation, uncheck the box to launch the Client Tool.
   
   Download the ECMPS Client Tool 2010 Q2 Release
   
   For additional assistance with the installation, click one of the following links:
   
   
   • Release Notes
   • Installation Guide
   • Minimum System Requirements
6. In each folder where the Client Tool is saved (which is C:\Program Files\ECMPS, by default), create two new folders named "Update" and "Downloads".
   
   
7. Change each Client Tool configuration to connect to the shared network database using the Configuration Utility.
   
   

The Configuration Utility is accessed through Start | All Programs | ECMPS | ECMPS Client | ECMPS Configuration Utility.



The main screen of the Configuration Utility will be displayed:



Select Configure Client Tool from the File Menu:



Update the Data Source and password based on information provided by your DBA:



Also, check the "Use Integrated Windows Security to connect to shared ECMPS database server?" check box if your DBA indicates that you will be using Windows Integrated Security. For more information on Windows Integrated Security, click here to view a PDF on the Client Tool and Integrated Security.

After making the changes, click the OK button and close out of the Configuration Utility.

Start the Client Tool. The EPA Host System Login Screen should now display your shared network database as the Client Tool database: