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:

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.