Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio:

enter image description here

Where are those names stored?? Is there any way to clean up that list and remove some entries??

share|improve this question
up vote 5 down vote accepted

For SQL 2005:

C:\Documents and Settings\<USER>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

For SQL 2008:

C:\Documents and Settings\<USER>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin


  1. Shut down all instances of SSMS
  2. Delete/Rename the file
  3. Open SSMS

Edit: on MS Connect

share|improve this answer
Thanks - there's no way / utilty to peek inside those files and selectively delete out a single entry or two?? – marc_s Jun 9 '11 at 7:20
dunno. never tried it.. :-) – gbn Jun 9 '11 at 7:25

To remove all entries for new SQL 2014, you need to delete file:

C:\Users\(USER)\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin
share|improve this answer

When upgrading from one version of SQL Server Management Studio to another, e.g. 2014 to 2016, you can copy the SqlStudio.bin file from one directory to another and all of your connections will migrate to the new version.

  1. Shut down all instances of SSMS.
  2. Rename SqlStudio.bin to SqlStudio.bin.saved in "C:\Users\<username>\AppData\Roaming\Microsoft\SQL Server Management Studio\13.0\".
  3. Copy the SqlStudio.bin file from "C:\Users\<username>\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\" to "C:\Users\<username>\AppData\Roaming\Microsoft\SQL Server Management Studio\13.0\"
  4. Now open SSMS 2016 and you should see all of your old connections from SSMS 2014.

Note: If this doesn't work, you can delete the SqlStudio.bin file in the ...\13.0\ directory and rename SqlStudio.bin.saved to SqlStudio.bin to restore your old configuration.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.