Post reply

Preserve EM registered server and SQL server group

  • February 11, 2009 at 7:45 pm

    #201065

    Good morning

    I will be changing my pc soon and i want to preserve the setting in my EM (all the registered sql and sql groups) in my new pc what should I do?

    "-=Still Learning=-"

    Lester Policarpio

  • February 11, 2009 at 8:04 pm

    #942580

    Lester on my machine, my 8.0 list of names are in the following key in the registry:

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

    i don't know where the passwords are, but you could at least keep the list of servers...maybe someone else knows what other keys to export.

    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 11, 2009 at 8:13 pm

    #942584

    Thanks for the reply lowell. In another case of my officemate (he uses the same machine but different profile) the SQL groups are there in the EM but when he colapse to list the registered sql there are no items inside.

    "-=Still Learning=-"

    Lester Policarpio

  • February 11, 2009 at 8:24 pm

    #942586

    ok i think the per user settings are here:

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers

    for a user that is not logged in, i found a different set of servers here:

    HKEY_USERS\S-1-5-21-515967899-1220945662-839522115-500\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers

    his specific SID only connected to two of the servers that are available, whereas my Adminstrator login has about a dozern.

    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