Unable to add data connection.Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0,

Few days ago, I installed SQL Server 2005 on my Laptop. I opened up Visual Studio 2008 and tried to connect to SQL Server database. But, I got an error message:

Unable to add data connection.
Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

The solution for the above problem was to :

Install the following from Microsoft SQL Server 2008 Feature Pack RC0, June 2008
- Microsoft SQL Server 2008 Native Client
- Microsoft SQL Server System CLR Types
- Microsoft SQL Server 2008 Management Objects

if you do not have SQL 2008 then these features can be downloaded from:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en#filelist

After installing the components, close and reopen Visual Studio 2008, you should now be able to Add the database through your Server Explorer

Comments

kunal said…
Many Thanks....Worked for me...
June 2, 2009 at 5:28 AM
Marco Alves said…
It also worked for me. Thx.
June 2, 2009 at 6:56 PM
Hiran said…
Thank you alot and alot..This also work fine on me..Thanks again and again
October 28, 2009 at 2:49 AM
abdullah said…
Thanks a lot... Worked for me, too...
April 19, 2010 at 1:18 PM
bonvoyager said…
Thanks a Lot.. It worked absolutely.
August 4, 2010 at 5:34 AM
Anonymous said…
This is a good blog. Keep up all the work. I too love blogging and expressing my opinions
February 5, 2011 at 6:25 PM
Anonymous said…
Great work.. Keep it up.. Thnx for blogging
March 28, 2011 at 10:30 AM
Anonymous said…
THANK YOU VERY MUCH.
IT WORKED FINALLY!!!
August 11, 2011 at 8:05 AM
Anonymous said…
Hey there! Do you use Twitter? I'd like to follow you if that would be ok. I'm absolutely enjoying your blog and look forward to new posts.


my webpage ... waist to height ratio calculator
April 18, 2013 at 10:28 PM
Anonymous said…
Hi there to all, how is everything, I think every one is getting more from this web site, and your views are nice designed
for new visitors.

My site; High Shock Sensor
May 9, 2013 at 12:11 AM
Elad said…
I did exactly according to the instruction, and I still get the same error message... why???
when I install "Native client" - what to chose in the "Feature selection"? client components or sql server native client SDK?
May 23, 2013 at 1:46 PM
Anonymous said…
Thanks for Nice Article. I have one issue ,My requirement is i need to use save Dialog to download the Document. I need your help on this,. . Visit More Info :- Windows live mail help also Call +1-800-231-4635 (Toll Free) now for Windows live mail help & Support from Microsoft certified technicians.
May 20, 2014 at 1:20 PM
Windows live mail help said…
Thanks alot..work perfectly...:) do you want to more information Windows live mail support also Call +1-800-231-4635 (Toll Free).
December 10, 2014 at 12:46 PM
Post a Comment

Popular posts from this blog

Error when Installing SQL Server 2008 R2 Management Studio

Yesterday, I downloaded and tried installing the 64bit version of the Sql Express Mangement Studio, but I received the below error message   Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1. Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update This message was particularly baffling since my laptop was a new build and I had installed VS 2010 only. On further investigation I found that one of the software installation that I did had installed VS 2008 components. The Add Remove programs in Control panel wasn't helpful. I used the VS2008 uninstall tool from microsoft site http://go.microsoft.com/fwlink/?LinkId=105801 This removed the VS2008 instance completely. I reran the setup for Management Studio and all worked well. To do it manually try http://blogs.msdn.com/b/joy/archive/2008/10/21/how-to-remove-visual-studio-2008-manually.aspx Hope it works out for you..
Read more

Windows 7 and GoToMyPC - Configure the Domain Group Policy to allow GoToMyPC to send Ctrl-Alt-Del

After installing Windows 7, I was unable to logon to the office computer using GoToMyPC. It came up with an error message along the lines of ‘The Domain Group Policy for this computer does not allow GoToMyPC to send Ctrl +Alt +Del. please contact your administrator'. I tried following the instructions given in the documentation of GotoMyPC's 'Pro Administrator Guide' till point 7, which read, I quote "Locate the Group Policy Object (GPO) in the domain or sub-domain that contains the policy that is preventing GoToMyPC from sending Ctrl-Alt-Del.". I spent some time looking for this policy but couldn't. I then started digging further into this issue and came across the concept of 'Secure Attention Sequence' which is basically a special sequence of events that enables a user to log on or off a computer, and how Windows Vista/Windows 7 introduced a new group policy setting which controls whether or not software can simulate a SAS. I solved my pr...
Read more

Technical Team Lead Interview Questions

Following are some of the questions which can be asked for a technical team lead interview: a. if you have a non performing developer in your team, how will you deal with them (Question relates to Motivation)? b. Have you ever had a project, that you were working on was in danger of missing the deadline and were you able to bring it back to schedule? if so how? c. Have you ever been part of recruiting members of the team? d. What document will you give to your developer when developing a requirement. State the details that will be included the document. e. What are your strengths and weaknesses? f. if we ask your team, what will your colleagues describe as your strengths and weaknesses.
Read more