SQL 2008: SQL Server Management Studio 2008 Express failed to retrieve data

Published by

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

Microsoft KB Released on 8/08