Keeping Remote Login Names for Local Servers

You can retain remote login names for your local server.

  1. Use create login to create a login for each login from the remote server.
  2. Use sp_addremotelogin for the server to create an entry in master..sysremotelogins with a null value for the remote login name and a value of -1 for the suid. For example:
    sp_addremotelogin GATEWAY