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 Amazon Network Load Balancer (NLB) DNS, and then select Provider Options.
    Tip: To find the NLB DNS:
    1. Access the EKS cluster on which you have deployed Proficy Historian for AWS.
    2. Access the EC2 instance.
    3. In the navigation pane, under Load Balancing, select Load Balancers.
    4. Select the load balancer for which you want to find the DNS.
    5. In the Description section, copy the DNS name.
    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.