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

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

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


Share Tweet Send
Loading...