Linked Servers Editor (SQL Server)

Go Up to Microsoft SQL Server Object Editors

The Linked Servers Editor lets you manage basic properties and logins for a linked server.

To edit a linked server

1. Open an editor on the linked server. For details, see Opening an Object Editor.
2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:

Tab	Settings and tasks
Properties	This panel lets you work with settings in the following categories:
	General	Is SQL Server - Setting this check box indicates a linked server defined through Microsoft SQL Server. Any tables retrieved from the server are from the default database defined for the login on the linked server. Setting this check box disables the remaining OLE DB Provider settings. Product Name - The product name of the OLE DB datasource to which you are linking. Datasource - The name of the OLE DB provider managing access to the linked server. OLE DB Provider Name - Select the name of the OLE DB provider managing access to the specified linked server. Provider Location - The OLE DB location property corresponding to the linked server. Provider Connection String - The OLD DB provider-specific connection string that identifies a unique datasource. Catalog - The name of the catalog to be used when making a connection to the OLE DB provider.
	Server Options	Data Access Server - Indicates whether the target linked server is enabled for distributed query access. RPC Out Server - Lets you select the server with RPC encryption. RPC - Enables RPC encryption from the server. Collation Compatible Server - Indicates Change DIstributed Query execution against linked servers. If you select this option, Microsoft SQL Server assumes that all characters in the linked server are compatible with the local server, with regard to character set and collation sequence (or sort order). This option is for Microsoft SQL Server 8.0 or later. Lazy Schema Validation - This option lets you optimize performance by ensuring the query processor does not request metadata for any of the linked tables until data is actually needed from the remote member table. This option is for Microsoft SQL Server 8.0 or later. Use Remote Collation and Collation Name - Let you indicate that the linked server should use remote collation and select the name of the collation. This option is for Microsoft SQL Server 8.0 or later. Query Timeout - Type the query timeout value. This option is for Microsoft SQL Server 8.0 or later. Connection Timeout - Type the connection timeout value. This option is for Microsoft SQL Server 8.0 or later.
Logins	Includes a table listing every user who has a login on the target linked server and their local login names. Optionally, you can:
		Create a new login by clicking Add linked login button and providing the following information in the dialog that opens: SQL Server Authentication - Use SQL Server authenticated login credentials to login to linked server. If you choose this option, you must provide a Local Login Name. No Remote Login - Indicates that no remote login or password are required login to the linked server. All Users - All users will use the same login when connecting to the linked server. If you choose this option, you must provide a Linked Login Name and a Password. Local Login Name - Lets you select a local login name. Linked Login Name - Lets you type in a linked login name. Password - Lets you set a password.
		Select a login, click the Modify button, and change the login names and password.
		Select a login and click the Drop button to delete that login.
DDL View	For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.