Remote Servers Wizard (SQL Server)

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	1(enabled)
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:
   • Properties panel - for details, see Remote Servers (SQL Server) - Properties.
   • DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
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
Name	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.