Create and map login and user accounts

A SQL Server login that is mapped to a domain user group is required for communication between a PI AF SQL Server database (typically named PIFD) and the PI AF application service. Before starting this procedure, ensure that you have configured a domain group for the account under which the PI AF application service runs. Complete these steps on both the principal and mirror machines.

1. Open Microsoft SQL Server Management Studio, and connect to the SQL Server instance that stores the PI AF SQL Server database (PIFD).

2. Under the SQL Server instance, expand Security > Logins.

   1. Right-click the Logins folder and select New Login.

   2. To include the groups object type, click Search.

   3. Click Object Types in the Select User Group window.

   4. Select Groups in the Object Types window.

   5. Click OK to return to the window.

   6. In the Select User Group window, click Locations.

   7. In the Locations window, select the Entire Directory folder and click OK.

   8. Enter the domain user group and include the domain name in the Enter the object name to select field with this format:

   YourDomain\YourAFDomainGroup

   1. Click OK to return to the General page.

3. Select the Windows authentication option.

4. Select the User Mapping page.

5. Under Users mapped to this login, select Map in the PIFD database row.

6. Ensure that the User column for the PIFD row is set to the domain user group YourDomain\YourAFDomainGroup.

7. Under Database role membership for: PIFD, select db_AFServer.

8. Verify that the public role is selected; if it is not, select the public role check box.

9. Click OK to save the new SQL Server login.