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

Question

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?

Answer 1

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 and 2017.

SQL Server Management Studio 2017 delete the file C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio14.0SqlStudio.bin

SQL Server Management Studio 2016 delete the file C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio13.0SqlStudio.bin

SQL Server Management Studio 2014 delete the file C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio12.0SqlStudio.bin

SQL Server Management Studio 2012 delete the file C:Users\%username%AppDataRoamingMicrosoftSQL Server Management Studio11.0SqlStudio.bin

SQL Server Management Studio 2008 delete the file C:Users\%username%AppDataRoamingMicrosoftMicrosoft SQL Server100ToolsShellSqlStudio.bin

SQL Server Management Studio 2005 delete the file – same as above answer but the Vista path. C:Users\%username%AppDataRoamingMicrosoftMicrosoft SQL Server90ToolsShellmru.dat

These are profile paths for Vista / 7 / 8.

EDIT:

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

EDIT: You can simply press delete from the Server / User name drop down (confirmed to be working for SSMS v18.0). Original source from https://blog.sqlauthority.com/2013/04/17/sql-server-remove-cached-login-from-ssms-connect-dialog-sql-in-sixty-seconds-049/ which mentioned that this feature is available since 2012!