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

How to send email from your asp.net code?

' Visual Basic Sample - Sending SMTP Authenticated E-mail ' Please replace yourdomain.com in...

What will happen if I hit the memory limit?

If the worker process exceeds the private memory quota, IIS will recycle that pool which limits...

Understanding Physical and Virtual Directory Structures

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

Login URL for the Web Site Panel

For shared hosting - https://wsp.aspnethosting.co.uk

MS SQL 2008 and MySQL server addresses

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