Remote Servers Wizard (Sybase ASE)

Go Up to Sybase ASE 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, shut down and restart the server so the new values can take effect. When you have configured both servers, proceed to the steps below.

To create a new remote server using a wizard:

1. Open an object 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 (Sybase ASE) - 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 (Sybase ASE) - Properties

When creating or editing a remote server, this tab/panel builds an sp_addserver stored procedure call and a set of sp_serveroption calls defining and configuring a remote server. It lets you work with the following settings:

Setting	Description
Name	Provide a name for the remote server.
Network Name	Optionally, provide the server’s physical/network name?
Server Type	Select a server type of LOCAL or REMOTE.
Timeout Inactive Connections (only available with a Server Type of REMOTE)	Indicate whether SQL server should time out inactive physical connections with this remote server.
Network Password Encryption (only available with a Server Type of REMOTE)	Indicate whether encryption should be used to protect passwords sent to this remote server
Security Model (only available with a Server Type of REMOTE)	Security Model A: This is equivalent to the level of security in release 11.0.x and prior releases. Security Model B: Implements security using DCE, Kerberos, or NT LAN Manager.
Security Mechanism (only available with a Server Type of REMOTE)	Specify a security mechanism
Message Integrity (only available with a Server Type of REMOTE and a Security Model of SECURITY MODEL B)	If enabled, messages between the servers are checked for tampering.
Message Confidentiality (only available with a Server Type of REMOTE and a Security Model of SECURITY MODEL B)	If enabled, messages between the local and remote servers are encrypted.
Mutual Authentication (only available with a Server Type of REMOTE and a Security Model of SECURITY MODEL B)	If enabled, the local server authenticates the remote server by retrieving and verifying the remote server credentials using the security mechanism. The credentials of both servers are authenticated and verified.