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.
Author |
Topic |
sreehari
Starting Member
37 Posts |
Posted - 2006-05-19 : 12:27:41
|
Hi guysin 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 issueThanks 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. |
|
|
sreehari
Starting Member
37 Posts |
Posted - 2006-05-19 : 12:32:58
|
Hii 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 EMquote: 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.
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-19 : 12:39:55
|
>>i am connecting to the EMnot 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. |
|
|
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... |
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2006-05-22 : 10:13:14
|
Have your tried this in QAexec sp_MSdbuseraccess 'db'I believe the above is used by EM to display the DBsTim S |
|
|
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] |
|
|
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 |
|
|
|
|
|