You can create entries that map all remote logins to a single name.
This example creates an entry that maps all remote login names to the local name “albert”. All names are mapped to “albert”, except those with specific mappings. For example, if you mapped “pogo” to “bob”, and then the rest of the logins to “albert”, “pogo” still maps to “bob”.
create logn albert with password itsA8secret sp_addremotelogin GATEWAY, albert
sp_remoteoption GATEWAY, albert, NULL, trusted, true
If you do not specify logins as trusted, they cannot execute RPCs on the local server unless they specify passwords for the local server when they log in to the remote server. Users can run ct_remote_pwd to specify a password for server-to-server connections when they use Open Client Client-Library. isql and bcp do not permit users to specify a password for RPC connections.
If users are logged in to the remote server using unified login, the logins must be designated as trusted on the local server, or they must specify passwords for the server when they log in to the remote server.