Logins from a remote server can be mapped to a local server in three ways:
A particular remote login can be mapped 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 can be mapped 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 can 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 Adaptive Server logins before you add the remote logins.
Only a system administrator can execute sp_addremotelogin. See the Reference Manual: Procedures.
