Solved

SQL 2000: Databases - No Items

Posted on 2008-11-03
3
1,413 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Express 10 28
Error running stored procedure 11 19
Microsoft SQL Server 2016 Setup..error 7 34
constraint check 2 20
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now