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

5 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........