• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1492
  • Last Modified:

SQL 2000: Databases - No Items

Hi experts

I restarted the MSSQLSERVER service and now there are no databases listed in EM. All I see now is 'No items'

Any help to view these databases would be greatly appreciated.

Thank you
0
haramsde
Asked:
haramsde
1 Solution
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
You need to register the servers you intend to control using the EM.
I don't have the gui since I work solely with SSMS, but its on top left, register servers. If your EM resides on the same machine as the server you would register netBUI name, or iP name, or localhost or dns name. Any of these should work.

/Marten
0
 
ursangelCommented:
Is taht the servers where visible before for your login.
Check the access permission for your login user.
More over, theer should not be a reason that you dont see any server if its registered properly.
Any way try registering the same again.
Right click on 'Server' --> you will get an option of New SQL server Registration.
Select the server you wish to register with.
0
 
haramsdeAuthor Commented:
I restarted the services again and it started working - bizarre! Thank you for your comments. I'm going to request having the points refunded.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now