SEARCH
Knowledgebase: MSSQL
Error 916 for Microsoft SQL Server Management Studio
Posted by - NA - on 11 August 2009 02:42 PM

If, when opening Microsoft SQL Server Management Studio, you receive the following error: The server principal <username> is not able to access the database <databasename> under the current security context. (Microsoft SQL Server, Error: 916)

The following steps should fix the problem:

1. In Object Explorer, click Databases
2. Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”
3. Right click the column headers and deselect “collation”
4. Refresh Databases

(156 vote(s))
Helpful
Not helpful
Comments (1)
Arvand Sabetian
19 November 2010 04:22 AM
This is pictured step by step in the following blog article http://blog.arvixe.com/how-to-fix-the-the-server-principal-is-not-able-to-access-the-database-error-in-microsoft-sql-server-management-studio/
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).