Create and map a SQL Server login

Before you begin, verify that you have configured the domain user group for PI AF before you map the domain user group required for communication between PI AF SQL Server database and PI AF application service. See Configure domain group for the PI AF Application Service.

An SQL Server login that is mapped to the domain user group is required for communication between PI AF SQL Server database and PI AF Application Service.

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

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

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

   2. Enter the domain user group including the domain name (YourDomain\YourAFDomainGroup) in the Login name field.

3. If you receive a message that the value entered is invalid, it is necessary to search for a group name. In order to do such a search, you must manually include the Groups as a search object type. To include the groups object type:

   1. Click Search.

   2. In the Select User Group window, click Object Types.

   3. In the Object Types window, select Groups.

   4. Click OK to return to the Select User Group window.

   5. Enter the domain user group, including the domain name YourDomain\YourAFDomainGroup, in the Enter the object name to select field.

   6. Click OK to return to the General page.

4. Select the Windows authentication option.

5. In Default database, select PIFD.

6. Select the User Mapping page.

7. Under Users mapped to this login, select the Map check box for the PIFD database row.

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

9. Under Database role membership for: PIFD, select the db_AFServer check box.

10. The public role should be selected by default; if it is not, select its check box.

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