Configure the OLE DB Provider as a Linked Server Manually

About this task

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

This topic describes how to configure the OLE DB provider as a linked server manually. You can also configure it automatically.

Procedure

  1. From the Start menu, open the SQL Server Enterprise Manager.
  2. Select an SQL server, and open the Security folder.
  3. Right-click the Linked Servers folder, and select New Linked Server.
    The Linked Server Properties window appears.
  4. Enter a name for the linked server, such as iHist.
  5. In the Provider Name field, select Historian OLE DB Provider.
  6. In the Data Source field, enter the name of the Historian server, and then select Provider Options.
    The Provider Options window appears.
    Note:
    • Select the Level Zero Only option only if using older versions of SQL server. 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.
  7. Select OK.
  8. If Historian security is enabled, enter a Historian username and password.
  9. For SQL Server 2008 (32-bit/64-bit), follow these steps:
    1. Select Security.
    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.
  10. Select OK.
    The linked server is created.