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

Fix - Session Timeout after some seconds in umbraco installation

Problem statement Umbraco installation is throwing 401 error while uploading images....

Can I Send Emails without SMTP authentication?

Linux Shared Hosting  With Linux Shared Hosting, we allow sending emails without SMTP...

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...

Error 80004005 The Microsoft Jet Database Engine Cannot Open the File

Following are the possible causes of this error: This error usually occurs when database file or...

Error 3241: The media family on device is incorrectly formed

Sometimes we may receive the below error message when restoring the database from the backup file...

  • 0 Users Found This Useful

Was this answer helpful?