Remote Servers Editor (SQL Server)

Go Up to Microsoft SQL Server Object Editors

The Remote Server Editor lets you manage the connection and security properties for a remote server, and manage the associated logins.

To edit a remote server

1. Open an editor on the remote 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	Lets you work with the following settings:
	Server Type	Displays the server type, LOCAL or REMOTE. The local server routes all commands to the remote server. To communicate with a remote server, you log into a local server and submit your remote procedure calls for remote servers. The remote server receives remote procedure calls from the local server and processes them accordingly.
	Publication Server	Specifies database publishing. When replication is installed, this option permits the tables of a database to be published for replication. When selected, this option enables publication. When not selected, this option disables publishing, drops all publications, and unmarks all transactions that were marked for replication in the transaction log.
	Distribution Server	Enables the remote server to be a distribution server.
	Subscription Server	Specifies database subscriptions. When selected, the database can be subscribed for publication. When not selected, the database cannot be subscribed for publication.
	Publisher/Subscriber	Enables the remote server to be a publisher/subscriber server.
	Collation Compatible Server	Indicates Change DIstributed Query execution against remote servers. If you select this option, Microsoft SQL Server assumes that all characters in the remote server are compatible with the local server, with regard to character set and collation sequence (or sort order).
	Data Access Server	Indicates whether the target remote server is enabled for distributed query access.
	RPC Out Server	Enables the remote server to execute stored procedures on the local server using a remote procedure call (RPC).
Logins	Includes a table listing the remote name, local name, and trusted status of logins for a remote server.Optionally you can:
		Click Add to open a dialog that lets you add a new login. The dialog displays or lets you provide: Remote Server Name - Displays the remote server name. Remote Login Name - Lets you specify a remote login name. All remote users - Select this box if you want to use this name for all remote logins. Local Login Name - Lets you select a local user name. Is Trusted - Lets you specify this remote login as a trusted login.
		Select a login, click Modify, and use the table above as a guide to modifying login options.
		Select a login, and click Drop to delete the 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.