Skip to content

SSMS config

SQL Server Managment Studio - 2008
http://www.developer.com/db/article.php/3587206

MRU – Most Recently Used

SSMS MRU

MRU is stored in a user file :
“C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat”.
to clear the MRU, remove or renamethis file, and restart Management Studio.
a user file, 1 per windows users

C:\Users\wmalesys\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell
C:\Users\wmalesys#\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell

SSMS does encrypt the saved password but has no capability to make it secure, you can decrypt such passwordrestrict access to your saved mru.dat file to help prevent unauthorized access to your server.
If you start SSMS using “run as”, this will messup your settings (encryption) if you use a sql-login and save the password.
It doesn’t use a seperate set !
<http://sqlserver-qa.net/blogs/tools/archive/2007/04/25/ssms-using-remember-password-option-and-save-passwords.aspx>