Managing Remote Servers

Users on a local SAP ASE can execute stored procedures on a remote SAP ASE. Executing an remote procedure calls (RPC) sends the results of the remote process to the calling process, which usually appears on the user’s screen.

Users on a local SAP ASE can execute stored procedures on a remote SAP ASE. Executing an RPC sends the results of the remote process to the calling process, which usually appears on the user’s screen.

To enable RPCs, the system administrator and system security officer of each SAP ASE must execute the following steps:

On the local server:
- System security officer – use sp_addserver to list the local server and remote server in the system table master..sysservers.
- List the remote server in the interfaces file or directory service for the local server.
- Restart the local server so the global variable @@servernameis set to the name of the local server. If this variable is not set properly, users cannot execute RPCs from the local server on any remote server.
On the remote server:
- System security officer – use sp_addserver to list the server originating the RPC in the system table master..sysservers.
- To allow the user who is originating the remote procedure access to the server, a system security officer uses create login, and a system administrator uses sp_addremotelogin.
- Add the remote login name as a user of the appropriate database and grant that login permission to execute the procedure. (If execute permission is granted to “public,” the user does not need to be granted specific permission.)

The figure below shows how to set up servers for remote access.

Graphic shows two servers and the steps you must perform to allow remote procedure calls between them. Under the first server (named rose) are the steps: sp_addserver ROSE, local sp_addserver ZINNIA interfaces files must have an entry for ZINNIA Under the second server (named zinnia) are the steps sp_addserver ROSE sp_addlogin joe sp_addremotelogin ROSE, joe sp_adduser joe (in the appropriate database) grant execute on procedure_name to joe

For operating-system-specific information about handling remote servers, see the installation documentation for your platform.

Adding Remote Logins
The system security officer and system administrator of any SAP ASE share control over which remote users can access the server, and the identity that remote users assume.
Password Checking for Remote Users
A system security officer can use sp_remoteoption to determine whether passwords are checked when remote users log in to the local server.
Getting Information About Remote Logins
sp_helpremotelogin displays information about the remote logins on a server.
Configuration Parameters for Remote Logins
Some configuration parameters affect RPCs.