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 :
It really worked. Thanks Rajesh
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 : you are getting this error after login or before login ?
Hi Rajesh,
Thank you so much.
I have same issue and solved it becoz of ur article.
Good article.
Thanks
Sunil Kadu
Thanks you so much Sunil...keep reading my blog.
very Nice article, solved my problem.
Thanks
----------------
Ashish Dager
Adros System
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.........................
@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 ??
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??????
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
thank you so much this helped me really
Rajesh its really working thanks lot but what was the problem? what cause this?
Post a Comment