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

Can I have more than 1 database with my MS-SQL account?

Yes, please create a support ticket for more information. The quota of the MSSQL database came...

How to connect to SQL Server 2000 using Enterprise Manager?

To connect to your Microsoft SQL Server database using Enterprise Manager to manage your...

How to Transfer SQL database from My Database Server to your Database Server

From the Start Menu, select Programs -> Microsoft SQL Server -> Import and...

How to connect to SQL Server 2000 using Query Analyser?

To connect to your Microsoft SQL Server 2000 database using the Query Analyser, you will...

I get "SQL Server does not exist or access is denied" error when I tried to connect to MS SQL database on your server?

This error indicates that Enterprise Manager or Query Analyzer cannot make a connection the...