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

How to emulate register_globals in PHP 5.4

During our recent Linux server migration task, we faced following strange issue: Some websites...

500 Internal Server Error

In Windows hosting, sometimes you may get error message 500 Internal Server Error for scripts...

Server Error in '/' Application in WebsitePanel :: Windows Server 2003 VPS

You may receive the following errors when running WebsitePanel installed on Windows 2003 server:...

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

Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1

This error occurs because the field name that you used in the query syntax does not exist. Often...

  • 0 Users Found This Useful

Was this answer helpful?