Error when connecting with MS SQL Managment Studio to MS SQL Server 2008

If you receive Microsoft SQL Server, Error: 916, when you connect with Microsoft SQL Studio:

The server principal "XXXXX" is not able to access the database "XXX" under the current security context. (Microsoft SQL Server, Error: 916)

You need to unselect the Collation for the databases.

  1. Navigate to 'Databases' in Object Explorer and open Object Explorer Details in that context

  2. Right click on the column header and unselect 'Collation'

  3. Refresh the server in Object Explorer and enumerate the databases

You can also install Microsoft SQL 2008 Service Pack 1, which will also fix the issue.