When using Microsoft SQL Server Management Studio 2008 to connect and manage a database
if you clicked the “Database” node within “Object Explorer” may received the message:
The server principal “username” is not able to access the database “databasename” under the current security context. (Microsoft SQL Server, Error: 916)
The server principal “username” is not able to access the database “databasename” under the current security context. (Microsoft SQL Server, Error: 916)
When you clicked the “Database” node in the Object Explorer Panel in the background SQL Server Management Studio 2008 execute an T-SQL query to retrieve a list of databases along with additional information about those databases, one of those information is collation, which didn’t have a permission to do for scan every database.
Fix:
- In Object Explorer, click Databases
- Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”
- Right click the column headers and deselect “collation”
- Refresh Databases.
