Grant permissions for PI AF Diagnostics utility

To use the PI AF Diagnostics utility, you need to grant the db_AFadmin database role to the SQL Server Login.

1. In Microsoft SQL Server Management Studio, connect to the SQL Server instance in which the PI AF database (PIFD) resides.

2. Under the SQL Server instance, expand the Security folder; then expand the Logins folder.

3. Right-click the login that corresponds to the appropriate Windows user and select Properties.

4. Select the User Mapping page.

5. Select the row for the PIFD database.

6. Select Map next to the PIFD database.

7. With the PIFD database still selected, select db_AFadmin under the Database role membership for: PIFD list, as shown in the following screenshot.

   

8. Click OK to save your changes and close the Microsoft SQL Server Management Studio.