Prune the servers in the Connect To dialog in SSMS
March 18th, 20097
Prune the servers in the Connect To dialog in SSMS
March 18th, 20097
Keeping for posterity but Microsoft did fix this in a not-so-intuitive way. See this answer and this blog post.

I have seen many people ask for ways to delete entries from SSMS' "Connect to Server" server name list.  The short and official answer is, you can't.  There is an unofficial answer, though.

Right now you have an all-or-nothing approach.  In SQL Server 2005, you can shut down SSMS, delete the file mru.dat, and restart SSMS.  For SQL Server 2008, you need to find the file SqlStudio.bin, and do the same thing.  The next time you open SSMS, the list should be empty.

My biggest concern is that this method is not documented (and therefore not supported), and it is unclear what other settings you might lose when doing so.

I tried looking at SqlStudio.bin with a hex editor, and it's clear that while we can see the entries, we aren't meant to modify them. In turn, I posted suggestion #424800 to Microsoft via Connect, asking them to expose the MRU list to us and make it easier to manage. So far, no dice.

By: Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.

7 Responses

  1. Eray says:


  2. Josh says:

    @Paul: Why is it a long dead post?  With Microsoft, things never get fixed.  I am still having this problem as are many others.  They just dont fix problems anymore – much like the bug they introduced with SQL Server 2005 "SSIS" and its inability to deal with variable width input files while DTS could handle it with no problem.

  3. Paul says:

    I know this is a long dead post, but it is possible.

  4. AaronBertrand says:

    Thanks for the update Bill!  The additional information is appreciated.

  5. billramo says:

    Hi Aaron, The other things that you lose with this approach includes SSMS specific Tools | Options settings, OE Details List View Customizations, the MRU list for OE Details Search, and MRU for Reports.
    Bill Ramos

  6. Steve says:

    Yet another annoying thing about SQL Studio.  I really wonder if the people who created studio have ever worked in a production environment.

  7. R Bowers says:

    Thank you.