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

All replies