Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We had some databases decommissioned recently, and my SQL Server 2000 Enterprise Manager still shows the server group I originally created containing those servers. I tried deleting the entire server group, but Enterprise Manager won't let me do so because the group still contains server registrations. When I right-click on individual server registrations to try and delete them one-by-one, Enterprise Manager tries to connect to the server and complains when it can't. I don't get to see the option to delete the server registration.

So ... how can I work around that and get these dead server registrations out of my Enterprise Manager configuration? Thanks :-)

share|improve this question
add comment

2 Answers 2

up vote 3 down vote accepted

On my test setup here, once the server connection times out (30 seconds), you can right click again and the menu will appear up. It only happens when you don't move the mouse to another server after clicking the first time.

share|improve this answer
add comment

Thanks! I also since found the registry key where these server registrations are stored:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.