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.
-
Navigate to 'Databases' in Object Explorer and open Object Explorer Details in that context
-
Right click on the column header and unselect 'Collation'
-
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.
Updated 4 months ago