Map Users’ Server IDs

You can map logins from a remote server to a local server.

You can map:

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.

Changing the mapping option

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.