How to fix Could not load file or assembly  'Microsoft.SqlServer.Management.Sdkc.Sfc' error
How To

How to fix Could not load file or assembly 'Microsoft.SqlServer.Management.Sdkc.Sfc' error

Editorial Team
Editorial Team

Follow us on Discord or Telegram to get access to free tutorials and updates.

I got this error when in Visual Studio 2013 when I tried to create a new connection in ADO.NET Entity Data Model. I was banging my head against the wall for several hours trying to fix the issue.

Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdkc.Sfc, Version=11.0.0.0, Culture=neutral, PublicKey Toekn = 89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.

I tried reinstalling MS SQL Server and Visual Studio. But it did not work. Finally, I got a solution.

Cause:

This happens when Visual Studio is unable to locate Microsoft.SqlServer.Management.Sdkc.Sfc, Version 11.0.0.0.

Solution:

To solve this issue, visit this link to download install the following files based on your CPU architecture.

https://www.microsoft.com/en-us/download/details.aspx?id=35580

For 64 bit OS:

  • ENU\x64\SharedManagementObjects.msi
  • ENU\x64\SQLSysClrTypes

For 32 bit OS:

  • ENU\x86\SharedManagementObjects.msi
  • ENU\x86\SQLSysClrTypes

Restart Visual Studio after installing. Happy coding….

via GIPHY