A System Security Officer can use sp_remoteoption to determine whether passwords will be checked when remote users log in to the local server. By default, passwords are verified (“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. The syntax is:
sp_remoteoption [remoteserver, loginame, remotename,
optname, {true | false}]
The following example sets trusted mode for the user “bob”:
sp_remoteoption GATEWAY, pogo, bob, trusted, true
