Xics Web Host
Please Login or Register


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

Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Also Read


Quick Navigation

Client Login



Remember Me