Post reply

How can i remove the history of server name selection in login window

  • February 4, 2009 at 8:03 pm

    #128454

    How can i remove the history of server name selection in login window:

    when i try to connect to a database in MS Sql 2005/8 and the database login with has a "Server Name" combo box allow user to select the previous database which connected before.... because we have many server had been connected before....but most as retired or no more use....

    is it possible to delete the un-use selection for in the "Server Name" combo box?

    thank you!

    Cheers;)

  • February 4, 2009 at 10:00 pm

    #938595

    the info is stored in the registry.

    open regedit and search for one of the servers you know you want to eliminate. you can see which ones exist from there.

    on my machine they appear in a few places, depending on the settings for SQL2000 EM or SQL 2005 Mangagement Studio.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 5, 2009 at 12:00 am

    #938617

    I tried to search the server connection name and it is not exist in the registry....

    any more info can help??:pinch:

  • February 5, 2009 at 5:03 am

    #938724

    I looked in the registry on my machine, and I think this is where you want to go to delete old servers you no longer connect to:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect

    mine has a list of 10 or so servers, all of which appear in the drop down for SSMS for me

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

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