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."

Knowledgebase

(16)Domains (17)Getting Started Downloads (34)Mail (7)SSL (36)cPanel/WHM/Linux (31)Pre-Sales Questions (5)PHP (45)WebsitePanel / Helm / Windows (7)MySQL (20)MSSQL (20)General (8)Connection/Site Viewing Issues (39)ASP .NET / ASP (33)Third Party Applications (6)Billing (3)PHP (7)eNom (24)Windows - Plesk

Knowledgebase: MSSQL

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))

Helpful

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: 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/

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.

Regard
Gokul

kamal

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 Reply to comment
Post a new comment Reply to comment

Full Name:
Email:
Comments:

CAPTCHA Verification
CAPTCHA Verification

Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).