Sunday, March 11, 2012

Enterprise Manager losing SQL Server registrations

Hi,

This is an infrequent problem but very annoying when it happens. Every so often, I go into Enterprise Manager only to find that all of my SQL server registrations have disappeared from the group and I have to add them all again. As it happens so infrequently I don't know if there's something I'm doing on my machine to make them all disappear.

Anyone got any ideas?

Thanks in advance,
MalteserDo you have any processes that delete or maybe "clean up" the windows registry? The registration information is kept there, but I can not think of any reason that you would lose it. Although, it is user specific information, so separate users could potentially have separate lists.|||However, I've checked my registry settings and under HKEY_CURRENT_USER/Software/Microsoft/Microsoft SQL Server/80/Tools/SQLEW/Registered Servers X/SQL Server Group all my servers are still listed but they're not showing through in the front end.

Any ideas?

No comments:

Post a Comment