Cannot connect to PI AF SQL Server database

When you cannot connect to the PI AF SQL Server database, try the following:

• The account under which the PI AF Application Service is running does not have permission to connect to the PI AF SQL Server database. Assign the db_AFServer database role to this account, as described in Create and configure SQL Server login.

• Check the PI AF server’s connect string for the correct server\instance and database name. For more information, refer to Modify the AFService.exe.config file.

• Check SQL Server to verify the PI AF SQL Server database is not offline.