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