Xics Web Host
Please Login or Register

Knowledgebase

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

Language:

Quick Navigation

Client Login

Email

Password

Remember Me

Search