Create a SQL Server user

If the target table (the table to which you want to connect) resides in a SQL Server instance other than the one in which the PI AF database (PIFD) resides, create a user and enable database access for the user as described in this topic.

1. Open Microsoft SQL Server Management Studio and connect to the SQL Server Instance that contains the target table.

2. Under the SQL Server Instance, expand the Security folder and then expand the Logins folder.

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. From the Default Database list, select the database that contains the target table.

7. Select the User Mapping page.

8. Select the row for the Database that contains the target table.

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

10. Click OK to close the Login – New window and save the new Login.

11. Expand the Databases folder, then the folder for the target database, and grant the necessary permission to execute the query that will be used to the Login just created.

    For example, if the query that will be used is a SELECT statement that specifies a single table, expand the Tables folder for the target database, expand the Tables folder, then right-click the table to which the query refers and choose Properties.

12. In the Table Properties window, select the Permissions page, then the Login, then Grant the Login the Select Permission. Click OK to close the Table Properties window.

13. Close Microsoft SQL Server Management Studio.