Thursday, May 14, 2009

Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc

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

7 comments:

ER said...

I'm so glad I found this!
really helped me resolving the assemble error i encountered! thanks very much!

Pequeten said...

Great it was driving me crazy, funny cause It didn't happen to me when I was using vs 2008 it happens with my new ide vstudio 2010.

Anonymous said...

thank you very very much..

kanchan said...

Thank u so much....now its working...
nice1........

kanchan said...

Thank u so much....now its working...
nice1........

Unknown said...

There's noticeably a bundle to know about this. I assume you made sure nice points in options also. usa online casino

joemill00077711 said...

A formidable share, I simply given this onto a colleague who was doing somewhat analysis on this. And he in fact bought me breakfast because I found it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love reading extra on this topic. If doable, as you become experience, would you thoughts updating your blog with extra details? It is highly useful for me. Big thumb up for this blog put up! casino slots