Create and configure SQL Server login

Create a SQL Server login, grant the SQL Server login account access to the PI AF SQL Server database (typically called PIFD), and grant the SQL Server user the db_AFServer database role.

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

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

3. Create a new login and enter a name in the Login name field.

4. Select the SQL Server authentication option.

5. Enter the password in the Password and Confirm password fields.

6. In Default database, select PIFD.

7. Select the User Mapping page.

8. Select the row for the PIFD database.

9. Select the Map check box for the PIFD database.

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

11. Click OK.