Microsoft SQL Server Management Studio cannot remember the password

Posted on February 25, 2022

In SQL Server Management Studio 2005, all credentials are stored in the mru.dat file.
However, SQL Server Management Studio 2008 and higher versions save the logins in the SqlStudio.bin file.
In order to remember the password, you need to create a file to the corresponding location.

SQL Server Management Studio 2012 and Above:

C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\<version>\SqlStudio.bin

SQL Server Management Studio 2008:

C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

SQL Server Management Studio 2005:
In Windows 8/7/Vista:

C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

Windows XP:

C:\Documents and Settings\%username%\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

In order to clear or remove the saved password just delete the mru.dat or SqlStudio.bin to the corresponding location

to join this conversation on Samprix.Already have an account? Sign in to comment