Published by exdone
Posted on January 16, 2009
Microsoft SQL Server, Error: 916
Error: the server principal “” is not able to access the database “” under the current security context
For those of you that connect to databases that are hosted by 3rd party providers, some of which are accustomed to leaving as many databases in auto-close mode as possible, you are first going to have to go to Object Explorer Details, right-click the column header list, and un-check Collation. At this point, if you refresh the Databases node in Object Explorer, you should again see all of the databases on the server, even those where you don’t have access. Strangely enough, OED still shows you some other data by default, that it probably shouldn’t (e.g. recovery model, last backup, owner).
For a more details explanation visit
SQL management 2008 error