Linked Server Properties (General Tab)
Use this tab to view or specify the following options.
Options
Linked server
Specify the name of the 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
Define a linked server through any of the available OLE DB providers, including SQL Server, by specifying the following:
- Provider name
- Specify the name of the OLE DB provider managing the access to the specified linked server.
- Provider options
- Display the Provider Options dialog box, where you view the various attributes of the linked server.
- Product name
- Specify the product name of the OLE DB data source you want to add as a linked server.
- Data source
- Specify the OLE DB data source property corresponding to the linked server.
- Provider string
- Specify the OLE DB provider string property corresponding to the linked server.
- Location
- Specify the OLE DB location property corresponding to the linked server.
- Catalog
- Specify the OLE DB catalog property corresponding to the linked server.