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.