Friday, December 7, 2012

The server principal " " is not able to access the database " " under the current security context. (Microsoft SQL Server, Error: 916)

The server principal " " is not able to access the database " " under the current security context. (Microsoft SQL Server, Error: 916)

This is the solution type of solution I found on the websites. Question is does it work, I dont't know because it didnt work in my condition so I really have no idea.


To resolve this issue:
1. After starting Management Studio 2008, select Databases in the Object Explorer once.
2. If the Object Explorer Details are not already showing, select View from the toolbar then select Object Explorer Details. 
3. Right click on any column header and make sure that “collation” is not checked. 

4. Refresh the database list by clicking the Refresh button located at the top of the Object Explorer Details panel.  You should have now have full access to your database at this point. 


Enjoy Have Bless day with MS SQL.

No comments:

Post a Comment

Popular Posts