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.
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.
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.
>>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.
Databases are not visibile in the EM
Posted - 05/19/2006 : 12:27:41
