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...
Marco Alves said…
It also worked for me. Thx.
Hiran said…
Thank you alot and alot..This also work fine on me..Thanks again and again
abdullah said…
Thanks a lot... Worked for me, too...
bonvoyager said…
Thanks a Lot.. It worked absolutely.
Anonymous said…
This is a good blog. Keep up all the work. I too love blogging and expressing my opinions
Anonymous said…
Great work.. Keep it up.. Thnx for blogging
Anonymous said…
THANK YOU VERY MUCH.
IT WORKED FINALLY!!!
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
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
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?
Unknown 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.
Thanks alot..work perfectly...:) do you want to more information Windows live mail support also Call +1-800-231-4635 (Toll Free).

Popular posts from this blog

Drupal - How to display webform node in a block?

Error when Installing SQL Server 2008 R2 Management Studio

Technical Team Lead Interview Questions