You may receive “Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc” while connection to database. I got the error when I tried to connect to SQL Server 2005 from Visual studio 2008 using server explorer. The exact error is,
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.
To solve this error you need to download following three updates from Microsoft.
- Microsoft SQL Server System CLR Types
- Microsoft SQL Server 2008 Management Objects
- Microsoft SQL Server 2008 Native Client
I found the solution form here. Thanks to Ahmed !!!
Thank you for your help, brother.
Thank you, this worked perfectly.
Its Worked out for me thanks
Thank you! You saved my butt!
thank you !
Installing below 2 components from Microsoft will solve the issue:
Microsoft SQL Server System CLR Types
Microsoft SQL Server 2008 Management Objects
Thank you very much!!!
These 2 files really solved my problem.
So many thanks!
Hi i have one problem in Mail Sending, if My Mail attachement Exceed the 8 MB then its not Sending,is any solution to this…
please let me know if any buddy has idea…
🙂
Thank you!
You saved my day!!!
Hi, I am getting the same error. but i am using SQL server 2000. what is the possible solution ?
regards,
Rahul
Thanks. Had this problem after uninstalling SQL Server 2008 and installed the 2005 again.
Installed the two components and the issue was resolved.
thanks
Thanks a lot dude!!!!!
Thank you so much boss……..
It helped me a lot.
Thanks for sharing this Chirag, worked perfectly on my machine.
Keep up the good work!
Thanks so much, this is exactly what I needed!!!
thanks miteshvmehta. I resolved my problem.
yes, but why? why do we need to download and install 2008 drivers to connect to a 2005 database? is the microsoft tech stack really that fragile??
mysql and oralce are looking better and better…
Thanks a lot. It works for me.
Thank you man!
thks for the help =)
Big Thanks! It works….
its nt working with in vs 2010.Wat to do nw???
That fixed it. Thank you so much for the information!
thanks indian folk!
Thank you so much!!!
That problem had been bothering me for some time, and you helped me solve it….
Great job!!!
I am using vs 2010 and sql server 2005
what should i do with the same error ?
Regards
Thanks it wrks with vs 2010 too.
Exelente solucion
Gracias.
Maybe you should make changes to the blog subject title Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc Tech Treasure to something more specific for your subject you make. I liked the post nevertheless.
just download and install the setups….
http://assemblytuts.blogspot.com
after installing just restart your computer…
I don’t believe, this really worked!
tks a lot man!
Gr8 it’s working
thanks buddy
thanks man
Issue resolved thanks
Hi am not able to install the same. got error as “The installation package is not supported by this processor type. Contact your product vendor.”
Pls assist.
Thank u for Solving my problem Dear’s
If u find some new inform me
sharad.tripathi.86@gmail.com
thanks a lot, it works 🙂 blessings and greetings from Ecuador 🙂
thank you…
thankyou it worked out.after installing jst restart vs2010
Cheers! Some links here:
Microsoft SQL Server System CLR Types:
http://go.microsoft.com/fwlink/?LinkId=123721&clcid=0×409
Microsoft SQL Server 2008 Management Objects:
http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0×409
Microsoft SQL Server 2008 Native Client:
http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0×409