Search Our Database
How to solve Microsoft SQL server error 916
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)
Solution:
- In Object Explorer, click databases
- Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”
- Right-click the column headers and deselect “collation”
- Refresh the databases.