Post reply

Remove entries from SSMS 2008 Login Connection Dropdown List

  • July 13, 2010 at 6:14 am

    #387339

    I've looked for a way to remove the unused or unwanted connections in the drop down list that appears when I start SSMS. I have found references that recommend removing "SqlStudio.bin" and "mru.dat" but haven't been able to locate either file on my pc.

  • September 2, 2010 at 2:12 pm

    #1215906

    If you are using Vista or Windows 7, it will be located here:

    C:\Users\<username>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell

    Unfortunately, it's an all or nothing solution. Here's a reference:

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/21e91e52-1e9e-4a7a-8636-aed4227fe9e7

  • September 3, 2010 at 5:20 am

    #1216096

    I'm using XP and can't find the mru file anywhere

  • September 3, 2010 at 9:44 am

    #1216248

    What version/edition of SQL Server Management Studio are you using?

  • September 3, 2010 at 9:48 am

    #1216252

    MS SQL 2008 Standard

  • September 3, 2010 at 9:52 am

    #1216256

    To find the version of SSMS, open SSMS, go to Help, then About.

  • September 3, 2010 at 9:55 am

    #1216262

    Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )

  • September 3, 2010 at 10:02 am

    #1216266

    Since you're on XP and using SSMS 2008, here's the file you should be looking for:

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

  • September 3, 2010 at 11:47 am

    #1216347

    I was not able to find this file either.

  • September 3, 2010 at 11:52 am

    #1216350

    Ignore that last response, I found it. Problem solved. Thanks for the help. Your timing was perfect, I was the victim of a self-inflicted MSSQL wound yesterday. I really needed to get the production server out of the dropdown list.

  • July 11, 2011 at 8:06 am

    #1351090

    And if you're on Vista or Windows 7, the path becomes

    C:\Users\<username>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy