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

by

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%\AppData\Roaming\Microsoft\SQL Server Management Studio\14.0\SqlStudio.bin

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.

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!

More Related Contents:

  1. How to add Active Directory user group as login in SQL Server
  2. SQL Server 2008 can’t login with newly created user
  3. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  4. What is the use of GO in SQL Server Management Studio & Transact SQL?
  5. What is the best way to auto-generate INSERT statements for a SQL Server table?
  6. How to see query history in SQL Server Management Studio
  7. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  8. Preferred Method of Storing Passwords In Database
  9. sql server invalid object name – but tables are listed in SSMS tables list
  10. SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?
  11. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  12. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  13. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  14. Query times out when executed from web, but super-fast when executed from SSMS
  15. How do you specify a different port number in SQL Management Studio?
  16. Unique constraint on multiple columns
  17. Access is denied when attaching a database
  18. How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?
  19. An attempt to login using SQL authentication failed
  20. Format SQL in SQL Server Management Studio
  21. Import / Export database with SQL Server Server Management Studio
  22. SQL Server Login error: Login failed for user ‘NT AUTHORITY\SYSTEM’
  23. SQL Server (localdb)\v11.0 explained
  24. The request failed or the service did not respond in a timely fashion?
  25. FOR JSON PATH results in SSMS truncated to 2033 characters
  26. If condition in SQL Server 2008
  27. Which are more performant, CTE or temporary tables?
  28. SQL WHERE.. IN clause multiple columns
  29. Configure Lucene.Net with SQL Server
  30. Forcing a query timeout in SQL Server

Leave a Comment