Knowledgebase

I get error when conneting to MS SQL 2008 server

If you get this error:

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

try this:

1) Bring Object Explorer Details window by selecting View --> Object Explorer Details in menu (or hitting F7)
2) In Object Explorer window click at Databases folder
3) In Object Explorer Details window right-click at the column header and deselect Collation
4) Refresh Databases folder.

Was this answer helpful?

 Print this Article

Also Read