> ## Documentation Index
> Fetch the complete documentation index at: https://kb.mochahost.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.