To enable remote users to keep their remote login names while using a local server:
Use create login to create a login for each login from the remote server.
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
