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. You can write Open Client applications 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 you can change it on your local server. 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 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 Chapter 5, “Managing Adaptive Server Logins and Database Users,” in the Security Administration Guide.
