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).
Provide the name you will use to refer to this linked 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.
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.
Type the product name of the OLE DB data source to add as a linked server.
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.
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).
Type the location of the database as interpreted by the OLE DB provider.
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.