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