Configuring the Historian OLE DB Provider as a Linked Server

About this task

The following steps are necessary in order to access a linked server via the OPENQUERY statement.

From the Start menu, open the SQL Server Enterprise Manager.
Select a SQL server and open the Security folder.
Right-click the Linked Servers folder and select New Linked Server from the right-click menu.
The Linked Server Properties dialog box appears.
Enter a name for the linked server, such as iHist, and then select the Historian OLE DB Provider from the Provider Name drop-down list.
Enter the name of the Historian server in the Data Source field, and then click the Provider Options button.
The Provider Options dialog box appears.
Note:
- Select the Level Zero Only option only when older versions of SQL Server are used. For better performance while executing small queries, select the Allow in Process option. Clear the option if larger queries are to be executed.
- For configuring the Historian 64-bit OLE DB provider as a linked server, the Allow in Process option is mandatory.
Click OK in the Provider Options dialog box.
If Historian security is enabled, enter a Historian username and password.
For SQL Server 2008 (32-bit/64-bit), follow these steps:
1. Click the Security tab.
2. Select the Be made using this security context option.
3. Enter a Historian username and password in the Remote Login and With Password fields.
Click OK in the Linked Server Properties dialog box to create the linked server.

For more information on linked servers, refer to the Microsoft SQL Server online Help.