Tuesday, June 23, 2009

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

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=, 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 -  Download Link


  • Microsoft SQL Server System CLR Types
  • Microsoft SQL Server 2008 Management Objects
  • Microsoft SQL Server 2008 Native Client



Download Instructions  -


  • Go to the mentioned link.
  • Hunt for these three bulleted text one by one.
  • Install the X86 verions.



Hope this helps.


Reference: Link1, Link2


Thanks & Regards,

Arun Manglick || Senior Tech Lead



No comments:

Post a Comment