haramsde
asked on
SQL 2000: Databases - No Items
Hi experts
I restarted the MSSQLSERVER service and now there are no databases listed in EM. All I see now is 'No items'
Any help to view these databases would be greatly appreciated.
Thank you
I restarted the MSSQLSERVER service and now there are no databases listed in EM. All I see now is 'No items'
Any help to view these databases would be greatly appreciated.
Thank you
Is taht the servers where visible before for your login.
Check the access permission for your login user.
More over, theer should not be a reason that you dont see any server if its registered properly.
Any way try registering the same again.
Right click on 'Server' --> you will get an option of New SQL server Registration.
Select the server you wish to register with.
Check the access permission for your login user.
More over, theer should not be a reason that you dont see any server if its registered properly.
Any way try registering the same again.
Right click on 'Server' --> you will get an option of New SQL server Registration.
Select the server you wish to register with.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't have the gui since I work solely with SSMS, but its on top left, register servers. If your EM resides on the same machine as the server you would register netBUI name, or iP name, or localhost or dns name. Any of these should work.
/Marten