Create a local user group for impersonated clients

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

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 for the users that require access to the database table.

5. Add to this group the accounts of all users that might be impersonated.

6. Click OK to add the selected users, and then click Close to dismiss the New Group window.

7. Close the Computer Management application.