Problem with MS SQL Server Management Studio 2008 connecting & managing databases on my shared host’s SQL Server 2005.
I couldn’t access my database, as I clicked the “Database” node within “Object Explorer” I received the message:
The server principal “username” is not able to access the database “dbName” under the current security context. (Microsoft SQL Server, Error: 916)
The dbName that said I didn't have permissions to was the first database in the list. Bummer, expecially when I'm in a hurry to get something done and now time to research. So I found the work around.
Solution to Microsoft SQL Server Error: 916
In Object Explorer of your remote connection, click Databases
Click “View / Object Explorer Details” in menu
Right click the column headers and deselect “collation”
Refresh the entire connection or maybe just the Databases
This works for me. Thanks, Tom Hall.