SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Databases are not visibile in the EM
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sreehari
Starting Member

India
37 Posts

Posted - 05/19/2006 :  12:27:41  Show Profile  Send sreehari a Yahoo! Message  Reply with Quote
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

United Kingdom
12543 Posts

Posted - 05/19/2006 :  12:29:08  Show Profile  Visit nr's Homepage  Reply with Quote
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

India
37 Posts

Posted - 05/19/2006 :  12:32:58  Show Profile  Send sreehari a Yahoo! Message  Reply with Quote
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

United Kingdom
12543 Posts

Posted - 05/19/2006 :  12:39:55  Show Profile  Visit nr's Homepage  Reply with Quote
>>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
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 05/20/2006 :  09:20:54  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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

USA
198 Posts

Posted - 05/22/2006 :  10:13:14  Show Profile  Reply with Quote
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 Posts

Posted - 06/14/2006 :  07:27:13  Show Profile  Reply with Quote
we have resolved the problem bringing online offline databases (...)
(PS: with SQL Server 2005 Management studio)
look at this http://www.mcse.ms/archive83-2005-5-1490199.html

Edited by - alfa270170 on 06/14/2006 08:19:31
Go to Top of Page

ACALVETT
Starting Member

United Kingdom
34 Posts

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

A
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000