Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server 'No Items' displaying under database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-10 : 07:50:44
Michael writes "I have SQL Server 2000 client on my workstation and I am connecting to a SQL Server 7.0 database. When I run Enterprise Manager it logins in fine but when I expand the database folder it displays a 'No Items' message. When I run Query Analyzer it displays all the databases and I can create tables and do everything else I need to in query analzyer. I have two computers with SQL Server 2000. One with service pack3 and one with no service pack and either way it will not display a database underneath the database folder in enterprise manager.
How do I get my databases to display in Enterprise Manager?"

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-02-10 : 17:47:48
Are you sure that EM and QA are connecting to the server as the same user?

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]
Go to Top of Page

andriancruz
Starting Member

38 Posts

Posted - 2004-02-11 : 23:54:55
Try to register again using your Enterprise Manager.
Go to Top of Page
   

- Advertisement -