In Microsoft SQL Server Management Studio (SSMS) a history of the server names you connect to are kept in the connection dialog’s server name field drop down list. Often servers can be replaced, you move on to other projects, connect to the wrong server, etc. and this list can become cluttered.
Here is how you clear items from this list.
- Open the Microsoft SQL Server Management Studio (SSMS) version you want to affect.
- Open the Connect to Server dialog (File->Connect Object Explorer, Object Explorer->Connect->Database Engine, etc.).
- Click on the Server Name field drop down list’s down arrow.
- Hover over the items you want to remove.
- Press the delete (DEL) key on your keyboard.
- Repeat 4-5 for each server you want to remove from the list.
There are other ways to do this as well, like removing your MRU.DAT or SqlStudio.bin file from SSMS’s directory. However, it’s a little more difficult and resets all of your customized settings (those in Tools->Options). This could lead to changes to your Transaction Isolation Level, Results or Text Editor settings, etc. That isn’t much fun since we all spend a bunch of time getting those setup just right.