In SQL Server Management Studio 2008, if I log into a shared hosting provider with many databases on one server, I cannot use the Object Explorer. This worked fine in 2005. Anyway to change this behavior?

It throws this exception:

  • The server principal "myusername" is not able to access the database "first-database-alphabetically-on-shared-server" under the current security context.

Accepted Answer

click View, Object Explorer Details. Then, open Databases. Finally, click the header columns and uncheck Collation.

Source: http://sqlblog.com/blogs/aaron_bertrand/archive/2008/07/07/a-little-management-studio-oops.aspx

I solved this for my own machine a while ago and had to look the issue back up. Hopefully this link and the links from there will help you find the answer if this doesn't. It seems familiar to what i had to do.

Written by Jeff Martin
This page was build to provide you fast access to the question and the direct accepted answer.
The content is written by members of the stackoverflow.com community.
It is licensed under cc-wiki