If you get the following error when trying to login to Microsoft SQL Server Management Studio then please see the fix below:
The server principal "username" is not able to access the database "somedatabase" under the current security context. (Microsoft SQL Server, Error: 916).
- Open SQL Server Management Studio.
- Connect to the server.
- In Object Explorer, click Databases.
- Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”.
- Right click the column headers and deselect “collation”.
- Refresh Databases.