Transferring SQL Server Registration Information Between Machines

Microsoft’s Richard Waymire gives a method for moving server registration information between client machines.

ITPro Today logo

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_USERSoftwareMicrosoftMicrosoftSQLServer80ToolsSQLEWRegistered 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

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like