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. The syntax is:
sp_addremotelogin remoteserver [, loginame [, remotename]]
If the local names are not listed in master..syslogins, add them as Adaptive Server logins with sp_addlogin before adding the remote logins.
Only a System Administrator can execute sp_addremotelogin. For more information, see the Reference Manual.
