Q
Manage Learn to apply best practices and optimize your operations.

Suddenly can't view databases from Enterprise Manager

SQL Server 7: regular users with read/write permission for a database can view databases, tables and data from Enterprise Manager. However, since yesterday, these users are no longer able to view databases, tables and data from EM, but they can still query from Query Analyzer. Could you tell me what happened? Thanks.

From time to time, Enterprise Manager basically loses stuff and fixing it is a matter of shutting down EM and restarting it. If your issues are not solved that way, then reinstall the client tools, because someone has screwed up something that Enterprise Manager needs.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close