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
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…