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.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

Error: Fatal error: Allowed memory size of xxxxxx bytes exhausted

Sometimes you may receive the following error message while accessing your PHP page: Error :...

Various Outlook/Outlook Express Error Codes

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

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

Google has reported my website as “Reported Attack Page", what should I do now?

When you try to browse your website or its URL, web browser may show you “Reported Attack Page”...

Error 1503: Error while restarting MySQL service on Windows server

You may need to restart MySQL services from Services on Windows server. While restarting service,...