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=220.127.116.11, 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.
This happens when Visual Studio is unable to locate Microsoft.SqlServer.Management.Sdkc.Sfc, Version 18.104.22.168.
To solve this issue, visit this link to download install the following files based on your CPU architecture.
For 64 bit OS:
For 32 bit OS:
Restart Visual Studio after installing. Happy coding….