Page History: Microsoft SQL Server and Management Studio Troubleshooting
Compare Page Revisions
Page Revision: 19/02/2010 17:19
Here is a list of common problems and errors that we have encountered on occasion with Microsoft SQL Server and/or Microsoft SQL Server Management Studio. We are listing these solutions as a courtesy for Microsoft developers working with Webvault servers and hosted SQL server databases on our network. If you would like further assistance while using a Microsoft SQL Server database hosted by Webvault please
contact our support team.
ERROR: The server principal XXX is not able to access the database XXX under the current security context.
This error sometimes occurs while loading the list of databases available on the SQL server while using Microsoft SQL Server Management Studio. The problem appears to relate to a bug with Management Studio. Here is one possible work around.
Please try using the following workaround and let us know if that helps:
1) Bring Object Explorer Details window by selecting View --> Object Explorer Details in menu (or hitting F7)
2) In Object Explorer window click at Databases folder
3) In Object Explorer Details window right-click at the column header and deselect Collation
4) Refresh Databases folder.
Courtesty of Stanislav Chiknavaryan, SQL Server Software Design Engineer
Full details on these forum threads:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354291&wa=wsignin1.0
http://forums.microsoft.com/msdn/showpost.aspx?postid=3531315&isthread=false&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0