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)
 Databases are not visibile in the EM

Author  Topic 

sreehari
Starting Member

37 Posts

Posted - 2006-05-19 : 12:27:41
Hi guys

in enterprise manager, when i connected to a server, i am not able to see the databases.when i click on databases node, i am getting like -no items. but i am able to connect to those databases through query analyzer.

any one can help me on this issue

Thanks in advance

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-19 : 12:29:08
Look at the registration properties for the server in enterprise manager and check that you have the same login as you are using for query analyser.
You will have to refresh the databases to see any new ones.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

sreehari
Starting Member

37 Posts

Posted - 2006-05-19 : 12:32:58
Hi

i am connecting to the EM with same login and password i am using for the query analyzer.
i am seeing nothing under database node in EM



quote:
Originally posted by nr

Look at the registration properties for the server in enterprise manager and check that you have the same login as you are using for query analyser.
You will have to refresh the databases to see any new ones.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-19 : 12:39:55
>>i am connecting to the EM
not sure what that means - but are you connecting to the server within em wit the same credentials? Right click on the server and select reqistration properties.

Did you refresh the databases.
You can also use the profiler to see the commands used to get the database list and run them under your profile.
I've seen some things get incorrect results if you are not sa but not the databases.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-05-20 : 09:20:54
check if the public role permissions have been modified, it's only a viewing problem in EM



--------------------
keeping it simple...
Go to Top of Page

TimS
Posting Yak Master

198 Posts

Posted - 2006-05-22 : 10:13:14
Have your tried this in QA

exec sp_MSdbuseraccess 'db'

I believe the above is used by EM to display the DBs

Tim S
Go to Top of Page

alfa270170
Starting Member

1 Post

Posted - 2006-06-14 : 07:27:13
we have resolved the problem bringing online offline databases (...)
(PS: with SQL Server 2005 Management studio)
look at this [url]http://www.mcse.ms/archive83-2005-5-1490199.html[/url]
Go to Top of Page

ACALVETT
Starting Member

34 Posts

Posted - 2006-06-14 : 07:40:31
Other than permissions, you can also get an empty DB List in Enterprise managager if tempdb is full.

A
Go to Top of Page
   

- Advertisement -