Post reply

How to get rid of unused servers ?

  • July 5, 2006 at 2:51 pm

    #113526

    In Connect to Server dialog box in SQL Server Management Studio, it has a drop-down box with a list previously connected servers. However, some of these servers are not used anymore. I want to get rid of them in order to make a room for new server names. So far I could not find a way how to do this, apparently SQL Server does not store these values in the Registry. Is there a way to get rid of them ?

    Thanks.

  • July 5, 2006 at 3:05 pm

    #647622

    Do you think they could be in

    C:\Documents and Settings\MyLoginName\My Documents\SQL Server Management Studio\Settings\CurrentSettings-2006-01-16.vssettings ?

    The date in the file name is the same as the date of the install, but the timestamp of the file is when I closed the Management Studio the last time. I did not find the server names from the Connect box there, but they can be encrypted.

    Try to connect to the new servers. I think it works by remembering last so many connected servers.

    Regards,Yelena Varsha

  • July 5, 2006 at 3:30 pm

    #647626

    Hi Yelena,

    Thanks for pointing to this file, I found it in my path. However I did not find any references to the server names, I opened this file in Notepad and used Find function. I thought that server names could be encrypted as you suggest, so I decided to cut this file and paste to another location in hope that SQL Server will recreate it from the scratch.

    When I started SSMS again, it indeed displayed a message something like cannot find a config file, but after that it re-created it, and this drop-down box looks the same as before, with all that old servers, so SQL Server probably stores that values somewhere else.

    I also tried to keep connecting to new servers in hope that it will "push out" all that old entries, but this technique does not seem to work either. It looks like once SQL Server memorized first 9 servers, it does not want to get any new ones.

     

    Thanks,

    Mark

  • July 6, 2006 at 2:03 pm

    #647828

    Found this in the registry:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect

    ...does that control the list?

  • July 7, 2006 at 12:12 am

    #647882

    Hi,

    no it think its not, I have server appearing in the list which aren´t available there. It seems that they are somehow saved encrypted.

    -jens.

  • July 7, 2006 at 11:04 am

    #648041

    Whoever finds out where the server names stored let all of us know.

    Regards,Yelena Varsha

Viewing 6 posts - 1 through 5 (of 5 total)

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