The current registry information is corrupt or not being recognized. The best thing to do is:
- Delete all the registrations in EM. Delete all the Server Groups.
- Delete all the data values below the registry key containing the EM information. In my system (Win XP with SQL 2000 SP3) the base key is:
- [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X]
- I deleted everything under that key.
- Open EM and register all your servers in whatever server group configuration you want.
- Close EM.
- Open Regedit or RegEdt32 and navigate to the above key (or whatever is appropriate for your configuration).
- Right click on the key and select Export. Specify a file name and destination (i.e. My Documents).
- Close Regedit (or RegEdt32)
Now next time you open EM and find your registrations gone follow this process:
- Delete any stragglers left in EM and close EM.
- Use Regedit or RegEdt32 to delete everything under the base key above.
- Close Regedit.
- Double click the file you saved in #4 above. Respond "Yes" (or "OK", I forget which) to the prompts.
- Open EM. Your servers should all now be there.
Its kind of hokey, but if you have more than 2 or 3 servers or a complex server group structure then its worth the effort. Its better than manually registering every server.
Note: Editting the Registry is performed at your own risk. Neither I nor my employer assume any responsibility for the results of following this process.