The effects of the “untrusted” mode depend on the user’s client program. isql and some user applications require that logins have the same password on the remote server and the local server. Open Client™ applications can be written to allow local logins to have different passwords on different servers.
To change your password in “untrusted” mode, you must first change it on all the remote systems you access before changing it on your local server. This is because of the password checking. If you change your password on the local server first, when you issue the remote procedure call to execute sp_password on the remote server your passwords will no longer match.
The syntax for changing your password on the remote server is:
remote_server...sp_password caller_passwd, new_passwd
On the local server, the syntax is:
sp_password caller_passwd, new_passwd
See “Changing passwords” for more information about changing your password.
