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.
Was this answer helpful? 0 Users Found This Useful (8 Votes)

Most Popular Articles

How to create my MySQL database?

After you are done with the database creation you can use the phpMyAdmin tool to manipulate the...
MySQL Database info: username, password, hostname, database name

Your MySQL database username - is the same as your Control Panel username. our MySQL database...
MySQL administration with phpMyAdmin

MySQL administration with phpMyAdmin NOTE: If You Have Purchased Hosting From Us  Your...
MS Access

MS Access is typically used in conjunction with Windows servers running a MSSQL database. We do...
Maximum number of databases per hosting account

By default our hosting accounts come with a maximum of 50 databases per account. If for any...