Remote Servers Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

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


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.


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).


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.