MS SQL
How to fix the error "The server principal " " is not able to access the database"?
When trying to connect to the MSSQL database with the Microsoft SQL Server Management Studio, you may get the following error
"The server principal " " is not able to access the database " " under the current security context."
The error you are getting is a bug/security issue in the latest MSSQL management program. A fix is available at
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354291
After choosing to login with the proper username, password and database name (which you specified in the control panel), please follow the following instructions:
- Bring Object Explorer Details window by selecting View -> Object Explorer Details in the top menu (or hitting F7)
- In the Object Explorer Details window click at Databases folder
- 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.
- Refresh Databases folder.