Skip navigation

Transferring SQL Server Registration Information Between Machines

When you use SQL Server 2000 Enterprise Manager to create server groups and register servers, where is the information stored—in the registry or a configuration file? For example, suppose I’ve created 100 server groups, and a total of 1000 servers. Assuming I’ve used Windows authentication for registering all the servers, can I copy the information from one client machine to another so that I don’t have to re-create the grouping and registration?

AInformation about servers and server groups is stored in the registry key HKEY_CURRENT_USER\Software\Microsoft\MicrosoftSQLServer\80\Tools\SQLEW\Registered Servers X. You can export and import this registry key set by using regedit.exe. This method isn’t supported, but should work for the scenario you describe.
—Richard Waymire
Program Manager Architect
Visual Studio Team System

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.