Create a local user group for PI AF application service account

If the table to which you want to connect resides in a SQL Server instance other than the one where the PI AF database (PIFD) resides, ensure that the table is accessible to the PI AF application service account.

1. On the computer where the SQL Server Instance resides, click Start > Administrative Tools > Computer Management.

   The Computer Management application starts.

2. Expand Local Users and Groups.

3. Right-click Groups and choose New Group.

4. In the New Group window, create a local user group to hold the identity of the PI AF Server Application Service.

5. Add the account of the user associated with the PI AF Server Application Service to the new group. If the PI AF Server Application Service is running under the NT AUTHORITY\NetworkService account, then add the PI AF server’s computer account to this group.

   Note: If the PI AF Server Application Service is running as the Local System or Local Service account, you most likely need to use SQL Server authentication (SQL Server and Windows authentication mode) instead of Integrated security. In order to avoid malicious attacks on the SQL Server, do not use Local System. Instead use the Network Service or Local Service account or a specifically created account with limited privileges.

6. Click OK to add the selected user.

7. Close the Computer Management application.