Password Checking for Remote Users

A system security officer can use sp_remoteoption to determine whether passwords are checked when remote users log in to the local server.

By default, passwords are verified (this is the “untrusted” mode). In trusted mode, the local server accepts remote logins from other servers and front-end applications without user-access verification for the particular login.

When sp_remoteoption is used with arguments, it changes the mode for the named user:

sp_remoteoption [remoteserver, loginame, remotename, 
     optname, {true | false}] 
For example, to set trusted mode for the user “bob”, enter
sp_remoteoption GATEWAY, pogo, bob, trusted,
    true