You can map logins from a remote server to a local server.
A particular remote login to a particular local login name. For example, user “joe” on the remote server might be mapped to “joesmith”.
All logins from one remote server to one local name. For example, all users sending remote procedure calls from the MAIN server might be mapped to “remusers”.
All logins from one remote server to use their remote names.
The first option can be combined with the other two options, and its specific mapping takes precedence over the other two more general mappings. The second and third options are mutually exclusive; you can use either of them, but not both.
Use sp_dropremotelogin to remove the old mapping.
Use sp_addremotelogin to add remote logins:
sp_addremotelogin remoteserver [, loginame [, remotename]]
If the local names are not listed in master..syslogins, use create login to add them as SAP ASE logins before you add the remote logins.
Only a system administrator can execute sp_addremotelogin. See the Reference Manual: Procedures.