Add a user account to PIMLWindows database

Use the following procedure to add a basic user login account to the PIMLWindows database with read/write privileges. You must take these steps after the PIMLWindows database file has been attached.

1. Open SQL Server Management Studio (Express) and connect to the appropriate SQL Server that contains an instance of the PIMLWindows database.

2. Select the computer.

3. In the tree, expand Security.

4. Right-click Logins and select New Login.

5. On the General page follow these steps:

   1. Select the appropriate authentication for each one of the PI Manual Logger components (PC Client, Windows Services, and Web Services).

      Microsoft recommends that you choose Windows Authentication, which may not be possible for the Web Services. If, however, Kerberos Delegation is not enabled in your domain, then you might need to use SQL Server Authentication for PI Manual Logger Web Services connection. Consult your Network Administrator and/or Web Server Administrator for help.

      According to Microsoft documentation, SQL Server Authentication may be necessary if you have a workgroup rather than a domain, or if you have users connecting from different, non-trusted domains. For details on the different authentication methods in SQL Server, consult Microsoft documentation.

   2. Choose one of the following actions:

      • For Windows authentication, enter the Windows user in the Login name field. Click Search to find the exact network username.

      • For SQL Server authentication, enter the SQL Server login name and password.

   3. In the Default Database box, select PimlWindows.

6. On the User Mapping page follow these steps:

   1. In the Map column select PimlWindows. Verify that the User column for PIMLWindows defaults to the same Windows user you entered on the General page.

   2. In the Default Schema column for PIMLWindows, enter dbo. Note that the Default Schema field cannot be populated for a Windows group; 'dbo' will be assumed.

   3. In the Database role membership for PimlWindows pane at the bottom of the window, select the db_datawriter and db_datareader check boxes for basic read/write privileges. Verify that Public role membership is also selected.

7. Click OK to save your settings.

8. Close SQL Server Management Studio.