Linked Server Properties (General Page)
Use this dialog box to configure properties for linked servers.
Options
- 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.
- 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.
- Provider string
Type the unique programmatic identifier (PROGID) of the OLE DB provider that corresponds to the data source.
- 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.
With SQL Server 2005 Service Pack 2, you can test the ability to connect to a linked server. In Object Explorer, right-click the linked server, and then click Test Connection.
See Also
Other Resources
sp_addlinkedserver (Transact-SQL)
Configuring Linked Servers for Delegation
OLE DB Providers Tested with SQL Server