Dev License: This installation of WHMCS is running under a Development License and is not authorized to be used for production use. Please report any cases of abuse to abuse@whmcs.com
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.

Was this answer helpful? 0 Users Found This Useful (7 Votes)

Powered by WHMCompleteSolution