Follow these rules when setting up security model B for RPCs:
Both servers must be using security model B.
Both servers must be using the same security mechanism, and that security mechanism must support the security services set with sp_serveroption.
The System Security Officer of the local server must specify any security services that are required by the remote server. For example, if the remote server requires that all messages use the message confidentiality security service, the System Security Officer must use sp_serveroption to activate use message confidentiality.
Logins who are authenticated by a security mechanism and log into Adaptive Server using “unified login” will not be permitted to execute RPCs on the remote procedure unless the logins are specified as “trusted” on the remote server or the login specifies the password for the remote server. Users, when they use Open Client Client-Library can use the routine ct_remote_pwd to specify a password for server-to-server connections. A System Administrator on Adaptive Server can use sp_remoteoption to specify that a user is trusted to use the remote server without specifying a password.
