Remote Servers Wizard (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Wizards

Remote Servers are servers on a network that you can access through your local server. Instead of logging directly into a remote server, you can log into your local server and execute a remote procedure call to it.

Note: Only stored procedures are allowed against remote servers. You can use a linked server to execute distributed queries and stored procedures.

Before beginning

Before you can set up a remote server, you first configure both the local and remote servers to accept remote access. To configure the Microsoft SQL Servers for remote access, you need to log into each server. The table below describes the parameters you need to configure on each server:

Parameter Description

Remote Access


Remote Connections

Number of remote connections required

Remote Logins

Number of remote logins required

Remote Sites

Number of remote sites required

After setting these server configuration parameters, shutdown and restart the server so the new values can take effect.

To create a new remote server using a wizard:

  1. Open a creation wizard for a remote server. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Remote Servers (SQL Server) - Properties

When creating or editing a remote server, this tab/panel lets you work with the following settings:

Setting Description


The name for the remote server.

Server Type

Lets you specify a server type of 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

Select if the server is to publish data for replication.

Distribution Server

Select If the server is to manage the distribution database.

Subscription Server

This option applies if you want to deploy a subscription management application from the remote server.

Publisher/Subscriber Server

Select if the server is both a subscriber and publisher of replicated data.

Collation Compatible Server

Select if the server is to be collation compatible.

RPC Out Server

Select if the server is to serve as a RPC Out server.