SomeTimes after formating your computer, when you install sql server 2008.
When you try to connect your database and click on database menu to see the list of database, you will find windows alert showing you this below error.
Microsoft SQL Server Management Studio Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) Additional information: An exception occurred while executing a Transact-SQl statement or batch.(Microsoft.SqlServer.COnnectionInfo) The server principal "DatabaseName" is not able to access the database "Birdiethis" under the current security context. (Microsoft SQL Server, Error:916)
Please read below to find, how to solve this problem,
There is nothing to worry about, mostly user use to uninstall sqlserver software and install it again. then also they feel same problem.
Follow this steps :
Step 1: Open your sql server 2008,connect to database.
Step 2: click on view option for the top menu panel,then click to Object Explorer Details,
Step 3: You will see a panel will open at the right hand side,
Step 4: Right click on the header part of that panel, and unselect all option, as shown in the image,
Step 5: This will solve that issue, and you can use sql server 2008 without any error.
Hope this post will help you,