Solved

SQL 2000: Databases - No Items

Posted on 2008-11-03
3
1,419 Views
Last Modified: 2012-08-14
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
Comment
Question by:haramsde
3 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 22866200
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
 
LVL 5

Expert Comment

by:ursangel
ID: 22868025
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
 
LVL 1

Accepted Solution

by:
haramsde earned 0 total points
ID: 22868474
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question