If the local server and remote server are set up to use security services, you can use unified login on both servers using one of these two methods:
The system security officer defines a user as “trusted” with sp_remoteoption on the remote server. The user gains access to the local server using a “unified login” and executes an RPC on the remote server. The user is trusted on the remote server and does not need to supply a password.
A user specifies a password for the remote server when he or she connects to the local server. The facility to specify a remote server password is provided by the ct_remote_pwd routine available with Open Client Client-Library/C. See the Open Client Client-Library/C Reference Manual.
