Follow the steps below to create a linked server from the Object Explorer.
Step 1: Open SQL Server Management Studio and connect to an instance of SQL Server.
Step 2: In the Object Explorer, expand the node for the SQL Server database. In the Server Objects node, right-click Linked Servers and click New Linked Server. The New Linked Server dialog is displayed.
Step 3: In the General section, click the Other Data Source option and enter the following information after naming the linked server:
- Provider: Select the SQL Server Native Client Provider that corresponds to your version of SQL Server. For example, SQL Server Native Client 11.0.
- Data Source: Enter the host and port the TDS remoting service is running on, separated by a comma. Note that a value of "localhost" in this input refers to the machine where SQL Server is running so be careful when creating a linked server in Management Studio when not running on the same machine as SQL Server.
- Catalog: Enter the CData system DSN, CData QuickBooks Sys.
Step 4: In the Security section, select the option to have the connection "made using this security context" and enter the username and password of a user you created in the Users tab of the SQL Gateway.
This May Help,