Failed to retrieve data for this request Error in SQL Server


Saturday, February 6, 2010

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.

That's it,


Hope this post will help you,
if yes please put comment below of this page,
Rajesh Singh,
Asp.Net Developer
Indianic Infotech Ltd (India)
rajesh@indianic.com

12 comments :

Anonymous said...

It really worked. Thanks Rajesh

Anonymous said...

Hi,

My problem is that I can't go over de 1. Step because I get the error message "Failed to retrieve....", so it is not possible to go to Step 2.

I am using Windows 7. I don't understand why Ms complicates things. Those gays must resolve first all possible problems and only after that release to the users their software. I think that they are very irresponsible people that only care for money.

rajesh Singh said...

Rajesh : you are getting this error after login or before login ?

Anonymous said...

Hi Rajesh,

Thank you so much.

I have same issue and solved it becoz of ur article.

Good article.

Thanks
Sunil Kadu

rajesh Singh said...

Thanks you so much Sunil...keep reading my blog.

Adros System said...

very Nice article, solved my problem.


Thanks
----------------
Ashish Dager
Adros System

shilpa mour said...

u hav explained things very nicely bt my problem is tat instead of d option "object explorer details" i m gettin d option "summary" . plz help.........................

rajesh Singh said...

@Shilpa : Try to press F7, might that help or in summary option just try to continue with other steps..

Which version of SQL server you are using ??

shilpa said...

hi this is shilpa again. i m still not able to resolve my problem nd my sql server version is 2005. i m trying to use sql server 2005 with visual studio 2010. plz suggest something.after right clicking on the panel which opens for summary option, should i make some changes in the security option, to give some rights to a particular username or password or something like tat? if yes, how??????

Anonymous said...

hi this is siva . i m not able to resolve my problem nd my sql server version is 2008 r2 . i m trying to use sql server 2008 r2 with visual studio 2008. plz suggest something.after right clicking on the panel object explorer open by pressing f7 but i dint see any panel in right hand side


step 3: You will see a panel will open at the right hand side

Anonymous said...

thank you so much this helped me really

Anonymous said...

Rajesh its really working thanks lot but what was the problem? what cause this?