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

MS SQL 2008 and MySQL server addresses

MSSQL 2008 server addresses are: sql2008.aspnethosting.co.uk sql2008r2.aspnethosting.co.uk...

How to enable remote IIS management for my site?

Login to your hosting control panel here http://cp.aspnethosting.co.uk then click on Web - Web...

Understanding Physical and Virtual Directory Structures

Beyond home directory wwwroot, Microsoft Web sites also use the following:■ Physical...