Recommended configuration for Linked Server in Microsoft SQL Server

A very common use case for PI OLEDB Enterprise is to configure a Linked Server in Microsoft SQL Server, to expose the PI OLEDB Enterprise catalogs and tables as if they were native to SQL Server. This configuration allows applications, reports, and other components that leverage SQL Server tables, to access PI System data seamlessly.

To create a Linked Server, the PI OLEDB Enterprise provider must be installed on the SQL Server machine. The creation of a Linked Server is generally done with SQL Server Management Studio (SSMS) and requires the configuration of a series of parameters in three major categories: General, Security and Server options. The tables in this section summarize the recommended settings for these parameters.

Note: If you run SSMS under Windows 2008, Vista or later, you may need to start SSMS as administrator.