Export (0) Print
Expand All

Linked Server Properties (General Page)

Use this dialog box to configure properties for linked servers.

The text you must provide for the fields is different for each provider. For more information about major providers, a description of how each field is used for each provider, and samples for some common types of linked servers, see sp_addlinkedserver (Transact-SQL).

Linked server

Provide the name you will use to refer to this linked server.

SQL Server

Identify the linked server as an instance of Microsoft SQL Server. If you use this method of defining a SQL Server linked server, the name specified in Linked server must be the network name of the server. Also, any tables retrieved from the server are from the default database defined for the login on the linked server.

Other data source

Specify an OLE DB server type other than SQL Server. Clicking this option activates the options below it.

Provider

Select an OLE DB data source from the list box. The OLE DB provider is registered with the given PROGID in the registry. For information about specific providers, see OLE DB Providers Tested with SQL Server.

Product name

Type the product name of the OLE DB data source to add as a linked server.

Data source

Type the name of the data source as interpreted by the OLE DB provider. If you are connecting to an instance of SQL Server, provide the instance name.

Provider string

Type the unique programmatic identifier (PROGID) of the OLE DB provider that corresponds to the data source. For examples of valid provider strings, see sp_addlinkedserver (Transact-SQL).

Location

Type the location of the database as interpreted by the OLE DB provider.

Catalog

Type the name of the catalog to use when making a connection to the OLE DB provider.

To test the ability to connect to a linked server, in Object Explorer, right-click the linked server and then click Test Connection.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft