Configure SQL Server connection information

After the database file has been attached to the server, you need to enter SQL Server connection information before you can use PI Manual Logger PC Client, PI Manual Logger Windows Services, and PI Manual Logger Web Services.

1. As Administrator, run PIML Configuration Tools.

   • For PI Manual Logger PC or Windows Services, click Start > Programs > PI System > PI Manual Logger > PIML Configuration Tools.

   Note: When User Account Control (UAC) is enabled, you may need to right-click PIML Configuration Tools and click Run as administrator.

   • For PI Manual Logger Web Services, run PIMLTools.exe in the PIPC\PimlWebServices folder.

2. In the PI Manual Logger Configuration Tools window, click the Database tab.

3. Double-click Setup Connection.

4. In the Database Connection Setup window, enter the computer name and SQL Server instance name in the SQL Server Name field, for example weathertop\sqlexpress. You can also use the default instance name of MSSQLSERVER.

   Note: The name is not case sensitive.

5. In the Database Name field, select a database from the drop-down list. Ensure that the database name is the same as it appears in Management Studio.

   Note: The name is not case sensitive.

6. If Windows Authentication mode is configured for your SQL Server instance, select the Use my Windows credentials check box. Microsoft recommends that you use Windows Authentication when possible. Otherwise, clear this check box and provide the appropriate SQL Server login information.

7. Click Test to verify the connection and click OK to close the confirmation window.

8. Click Apply to close the PI Manual Configuration Tools window.