How to reset saved user/password in sql server management studio 2008

Question

One of my saved passwords in sql server management studio 2008 is wrong. I would like to wipe all saved accounts.

Answer 1

Hello,

Right click properties on the registered server that you would like to change the password. You can even change the authentication method, if you want to.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Adding to Alberto' suggestion,

You need to logon the server using login which has the right permission, see below from Books Online:

Requires ALTER ANY LOGIN permission.

If the CREDENTIAL option is used, also requires ALTER ANY CREDENTIAL permission.

If the login that is being changed is a member of the sysadmin fixed server role or a grantee of CONTROL SERVER permission, also requires CONTROL SERVER permission when making the following changes:

• Resetting the password without supplying the old password.
• Enabling MUST_CHANGE, CHECK_POLICY, or CHECK_EXPIRATION.
• Changing the login name.
• Enabling or disabling the login.
• Mapping the login to a different credential.

A principal can change the password, default language, and default database for its own login.


For more information on Alter Login see here: http://msdn.microsoft.com/en-us/library/ms189828.aspx

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.