none
Getting SSMS 2008 to forget or reset a stored password

    Question

  • The "Connect to a database engine" dialog in SQL Server Management Studio 2008 has remembered the wrong password for one user (using SQL Server authentication) on one of my database servers. Now even if I enter the correct password for this user and tell it to remember the password, it does not update the password it has stored. How can I get it to forget the password information it has stored for this user, so that I can enter the correct password and have SSMS remember it?
    Thursday, January 15, 2009 3:44 PM

Answers

  • Its not stored in the registry, its located here:

    %appdata%\Microsoft\Microsoft SQL Server\90\Tools\Shell\RegSrvr.xml

    But the password data is encrypted and you cannot change it in the XML file directly. The only way to change it, is to change the password in the UI and save the password from the dialog option.

    -Jens K. Suessmeyer

    Friday, January 16, 2009 9:39 AM
    Moderator

All replies

  • I think it is stored somewhere in the registry and some one might jump in and give you the requested tip.

    Meanwhile, I would like to mention that I am using the "Registered Servers" window to organize and mangage the access information to the different servers that I am working with. This is pretty easy to manage and maintain. If that interests you, look at this article: http://blog.sqlserver.me/2008/12/ssms-features-that-i-use-registered.html
    http://blog.sqlserver.me/
    Thursday, January 15, 2009 4:07 PM
  • Its not stored in the registry, its located here:

    %appdata%\Microsoft\Microsoft SQL Server\90\Tools\Shell\RegSrvr.xml

    But the password data is encrypted and you cannot change it in the XML file directly. The only way to change it, is to change the password in the UI and save the password from the dialog option.

    -Jens K. Suessmeyer

    Friday, January 16, 2009 9:39 AM
    Moderator