Connect to PI AF Server

1. Click Start > All Programs > PI System > PI SQL Commander Lite (64-bit).

2. In the Object Explorer pane, expand OLEDB Data Sources and right-click PI SQL Client and click Connect.

   

3. In the Data Link Properties window, in the AF Server field, type PI AF Server name. In the AF Database field, type PI AF database name or select one from the drop-down list.

   Note: The drop-down list in the AF Database field is available only if PI Web API Core Services is installed.

4. In the Authentication area, provide credentials for a Windows user account or select Trusted Connection to use your Windows credentials to connect to PI AF server.

5. Optional: Click the Advanced tab to specify additional connection parameters such as the initial catalog, command timeout, or protocol order.

   

   Note: To access the various PI AF data sources, PI System data references, and so on, you must enter login information for an account with valid permissions for the machine that runs PI AF server. For more information, see the topic "Firewalls and PI AF Security" in the PI Asset Framework (PI AF) Installation and Maintenance Guide available on the AVEVA Customer Portal Products page.

6. Click OK.

   A green arrow next to the data source icon indicates that the connection is successful.

   

   Note: Installation of PI SQL Data Access Server (RTQP Engine) requires you to connect to the PI SQL Client. For more information, see the PI SQL Data Access Server (RTQP Engine) Administrator Guide.

If PI SQL Data Access Server (RTQP Engine) is not installed or the PI AF Server machine is not accessible, you should see an error similar to the following: