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

I get Error reading web site information when i click my website in Websitepanel

A) this usually means that eithera) you have deleted wwwroot/web.configb) edited...

How to configure web deploy/ webmatrix?

How to configure Web deploy & Webmatrix in WebsitePanel First log in WebsitePanel, navigate...

Conection String to MS SQL 2008 DB - example

In order to connect to SQL Server 2008 from Management Studio, Enterprise Manager, Query...

MS SQL 2008 and MySQL server addresses

MSSQL 2008 server addresses are: