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

We may receive following error when login to our database from SQL Server Management Studio (2008 R2):

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

Resolution:

  1. Start SQL Server Mangement Studio 2008 R2 in your local machine.
  2. Select Databases in the Object Explorer.
  3. If the Object Explorer details are not showing, select View from toolbar and then select Object Explorer Details.
  4. Right click on any column header and make sure that “collation” is not checked.
  5. Refresh the database list by clicking the Refresh button located at the top of the Object Explorer Details panel.

Related Articles

While running my ASP.NET Application, I am receiving full trust level error

Exception Details System.Security.SecurityException: Request for the permission of type...

How do I fix HTTP Error 404 on my website?

Following are some of the most common reasons and solutions of 404 error. You might be typing...

Various Outlook/Outlook Express Error Codes

Error Code Description 0x800CCCF4 HTTPMail Your outlook settings may...

Operation must use an updateable query Microsoft OLE DB Provider for ODBC Drivers error '80004005' .[Microsoft] [ODBC Microsoft Access Driver]

This error usually occurs when you try to insert or update data in MS Access database i.e. you do...

How to Fix Runtime Error on Website with SDF Database?

Problem Statement Runtime error on website having Database on SDF file. Solution Start IIS...

  • 0 Users Found This Useful

Was this answer helpful?