Cannot expand Databases in Management Studio

Error:

Management Studio Express 2008 to access my shared hosted SQL 2005 / 2008
Standard. I can login to my Db and run sql statements in management studio.
However when I try to expand the "Databases" in "Object Explorer" I get:

"The server principal "my_username" is not able to access the database
"someone_elses_DB" under the current security context. (Microsoft SQL
Server, Error: 916) ".



Solutions:

The published work-around is to remove the collation column from the details
view:

1. Connect to MSSQL Management Studio
2. Press F7 to open Object Explorer Details window
3. On the right pane, click on 'Databases' folder as shown below


4. On the right pane, click on one of the column headings (eg. Name, Policy Health State, etc.)
5. Un-check 'Collation' as shown below


6. Press F5 to refresh, and you should see the databases listing

Was this answer helpful?

 Print this Article

Also Read

How do I configure the SQL Server Client connection protocol?

To connect to a remote MS SQL Server over the Internet using SQL clients (Enterprise Manager,...

I want to use a domain I already own, but do I have to transfer my domain name to you?

If you already own a domain name and you wish to use that domain name with a hosting account on...

Do you support MSDE 2000?

No. We do not support MSDE 2000. The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a...

I am able to view and access a SQL database other than my own while connected with Enterprise Manager, Query Analyzer, or the SQL Web admin. What is wrong?

...

How do I get a copy of MS SQL Enterprise Manager and Query Analyser?

Microsoft does not distribute MS SQL client tools individually, they are bundled with MS SQL...