Search code examples
visual-studio-2013sql-server-2014

Error: Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0'

I am using VS 2013 and SQL SERVER 2014 and I am trying to use entity framework to connect to the DB from VS 2013. I am getting test connection succeeded when adding the Entity data model but getting the above error.

Error :Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0' System cannot find the file specified

I tried so many solution, I re-installed SQLSysClrTypes.msi, SharedManagementObjects.msi, DB2OLEDBV5_x64.msi and vcredist_x64.exe to resolve this ; but it did n't works.

Could any one please suggest me solution?

Thanks, Saloni

Solution

  • Just to stamp as the answer, let me rewrite in the answer block from my comments. Install the right Microsoft.SqlServer.Management.Sdk.Sfc version 11's SharedManagementObjects.msi from http://www.microsoft.com/en-us/download/details.aspx?id=35580, because it seems like the entity is using the previous SQL Server (2012).