Knowledgebase: MSSQL
When trying to connect to the MSSQL database with the Microsoft SQL Server Management Studio I get: "The server principal " " is not able to access the database " " under the current security context."
Posted by Arvand Sabetian (Import) on 19 February 2009 06:45 AM

A detailed blog post (With screen captures) was created by us for you, here.

The error you are getting is a bug/security issue in the latest MSSQL management program. Click here to see the fix.

After choosing to login with the proper username, password and database name (which you specified in the control panel), please follow the following instructions:

1) Bring Object Explorer Details window by selecting View -> Object Explorer Details in the top menu (or hitting F7)
2) In the Object Explorer Details window click at Databases folder
3) The default column header will consist of 'Name', 'Policy Health State', 'Recovery Model', .etc.
In Object Explorer Details window, right-click on one of the column headers and a list of options will open. Deselect Collation.
4) Refresh Databases folder.

If you are not sure how to do the steps above let us know and we can call you to walk you through them. Please call us at 1-888-278-4939 or submit a ticket

(185 vote(s))
Not helpful

Comments (5)
Timothy Callaghan
14 July 2009 08:22 PM
Thank you. This information was most helpful and allowed me to connect and use the Management Studio!
Arvand Sabetian
19 November 2010 04:23 AM
This is also pictured step by step here:
Gokul Borse
21 November 2012 11:34 PM
Hi Arvand Sabetian
I doing all that suggested in your link but still i'm getting same error, pls sugest any solution.

18 December 2010 11:19 AM
Thank you

i have that error not in open management studio but when try to generate script of my database at last step :( !!!
any idea ???
Arvand Sabetian
27 December 2010 03:51 AM
Kamal, please contact our support so we can evaluate the error and properly respond to your inquiry. Or, you are more than welcome to post the error here.
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).