Change provider properties for out-of-process configuration

Before you create a linked server, you need to set the provider properties for the PISQLClient provider. You only need to set the properties once because they apply to all linked servers using the PISQLClient provider. If you set the PISQLClient provider to run out-of-process, you need complete the additional configurations in this section.

1. Start SSMS and connect to the database engine.

2. In the Object Explorer pane, navigate to PI SQL Client OLEDB (Server Objects > Linked Servers > Providers > PISQLClient).

3. Right-click PISQLClient and select Properties.

   The Provider Options - PI SQL Client window opens.

4. Clear the Allow inprocess check box.

   

5. Click OK.