I have installed MS SQL Server R2 and if I try to update the model from database under EDMX file I am facing that error .
Could not load file or assembly MICROSOFT.SQLSERVER.MANAGEMENT.SDK.SFC version 11.0.0.0
Solutions:
- IF MICROSOFT.SQLSERVER.MANAGEMENT.SDK.SFC version 12.0.0.0 cannot find by Visual Studio
Goto:
http://www.microsoft.com/en-us/download/details.aspx?id=42295
DownLoad:
- Enu\x86\sharedmanagementobjects.msi for X64 OS OR
- Enu\x64\sharedmanagementobjects.msi for X64 OS (according to our computer)
- IF MICROSOFT.SQLSERVER.MANAGEMENT.SDK.SFC version 11.0.0.0 cannot find by Visual Studio
Goto:
https://www.microsoft.com/en-us/download/details.aspx?id=35580
DownLoad:
- Enu\x86\sharedmanagementobjects.msi for X64 OS OR
- Enu\x64\sharedmanagementobjects.msi for X64 OS (according to our computer)
- IF MICROSOFT.SQLSERVER.MANAGEMENT.SDK.SFC version 10.0.0.0 cannot find by Visual Studio
Goto:
https://www.microsoft.com/en-us/download/details.aspx?id=26728
DownLoad:
- Enu\x86\sharedmanagementobjects.msi for X64 OS OR
- Enu\x64\sharedmanagementobjects.msi for X64 OS (according to our computer)
After Intalled,and restart Visual Studio, you'll find everything work normally.
Could not load file or assembly MICROSOFT.SQLSERVER.MANAGEMENT.SDK.SFC version 11.0.0.0