Removing the remembered login and password list in SQL Server Management Studio

I’ve recently used our company’s spare laptop (that has a general user set up) while mine was being repaired. I’ve checked the “Remember password” option in SQL Server Management Studio when logging in to the database.

I need to clear the login and password information that I have used to prevent the next person that will use the laptop from using my login names and passwords. How can I do this?

  • Trigger to prevent Insertion for duplicate data of two columns
  • How to install fulltext on sql server 2008?
  • customer.pk_name joining transactions.fk_name vs. customer.pk_id joining transactions.fk_id
  • Paginated UNION ALL result - best performance
  • Selecting from another select statements results
  • Access SQL Server Insert blocked by Select
  • 5 Solutions collect form web for “Removing the remembered login and password list in SQL Server Management Studio”

    Another answer here also mentions since 2012 you can remove Remove cached login via How to remove cached server names from the Connect to Server dialog?. Just confirmed this delete in MRU list works fine in 2016.

    SQL Server Management Studio 2016 delete the file
    C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\13.0\SqlStudio.bin

    SQL Server Management Studio 2014 delete the file
    C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin

    SQL Server Management Studio 2012 delete the file
    C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin

    SQL Server Management Studio 2008 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

    SQL Server Management Studio 2005 delete the file – same as above answer but the Vista path.
    C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

    These are profile paths for Vista / 7 / 8.

    EDIT:

    Note, AppData is a hidden folder. You need to show hidden folders in explorer.

    For those looking for the SSMS 2012 solution… see this answer:

    Remove cached login 2012

    Essentially, in 2012 you can delete the server from the server list dropdown which clears all cached logins for that server.

    Delete:

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

    For SQL Server Management Studio 2008

    1. You need to go C:\Documents and Settings\%username%\Application
      Data\Microsoft\Microsoft SQL Server\100\Tools\Shell

    2. Delete SqlStudio.bin

    In XP, the .mru.dat file is in C:\Documents and Settings\Name\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM

    However, removing it won’t do anything.

    To remove the list in XP, cut the sqlstudio bin file from C:\Documents and Settings\Name\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell and paste it on your desktop.

    Try SQL

    If it has worked, then delete the sqlstudio bin file from desktop.

    Easy 🙂

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.