If the local server and remote server are set up to use security services, you can use unified login on both servers with either model, using one of these two methods:
The System Security Officer defines a user as “trusted” with sp_remoteoption on the remote server. With this method, a security mechanism such as DCE authenticates the user and password. The user gains access to the local server via “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. For more information about this routine, see the Open Client Client-Library/C Reference Manual.