Search our database

Microsoft SQL server error 916:

If you receive following error while using Microsoft SQL Server Management Studio 2008:

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

Solution:

  1. In Object Explorer, click databases
  2. Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”
  3. Right click the column headers and deselect “collation”
  4. Refresh the databases.

Tags: