In SQL Server 2008 and earlier version there was a file in the installation folder once deleted it would remove all the cached login from the Connect drop down of SQL Server Management Studio. Here is the direction for SQL Server 2008 and earlier version. However, in SQL Server 2012 product team has made it very easy for all of us. We can just select the connection name which we want to do remove and click on delete and it will immediately remove the entry. This way, instead of removing every single entry, you can pick and select the entry which you want to delete.
Let us see the same concept in following SQL in Sixty Seconds Video:
Related Tips in SQL in Sixty Seconds:
- Remove Cached Login from SSMS Connect Dialog
- Template Browser – A Very Important and Useful Feature of SSMS
- SSMS Feature – Multi-server Queries
- Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video
- Management Studio New Features
- Using SSMS Commandline Parameters
What would you like to see in the next SQL in Sixty Seconds video?
Reference: Pinal Dave (https://blog.sqlauthority.com)