Search Our Database

How to solve Microsoft SQL server error 916

Last updated on |

If you receive the 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)


  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.