Home > .NET, Vs2013, WCF > Microsoft.SqlServer.Management.Sdk.Sfc not found

Microsoft.SqlServer.Management.Sdk.Sfc not found

2014/05/10

In theory within an updated, state of the art system it should be all ok, but it is not always so.

I’m using a brand new installed windows 8.1 , with Visual Studio 2013 and SQL Server 2014; all with the latest updates.

In a new Web application i was adding an ADO.NET Entity Data Model, operation that i done a lot in the past.


However, this time when creating the new connection to Northwind (my original intent is to create a web service for test) i got the error:


Searching on Internet i have seen that i’m not alone with this problem.

Could be the combination of Visual Studio 2013 with the very new SQL 2014? could be that until Visual Studio 2012 + SQL 2012 there was not this problem? i don’t have a pc with Visual studio 2012 and i don’t have the time to create an install an vm to verify these conditions.

On c:\windows\assembly in windows 8.1 i can see


Effectively no Microsoft.SqlServer.Management.Sdk.Sfc version=11.0.0.0

Could be that this is a bug and it will be fixed, so i tried on a vm with Visual Studio 2010: here no problems for the creation of the model…

But in every case what does this part of the wizard? nothing more than add a connectionstring in the relative web.config section.

In the Visual Studio 2010 project i tried to connect the same Northwind on the same server which i tried to connect in the Visual Studio 2013 solution; in this case it was created this connectionstring:

<add name="NorthwindEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=mysql2014svr;initial catalog=Northwind;persist security info=True;user id=sa;password=thepwd;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

I pasted this connection string in the connectionstrings section of the Visual studio 2013 web.config, so the connection is already in place when adding the ADO.NET Data Model in the Visual Studio 2013 project:


Moreover, it can set my data model without problems:

Advertisements
Categories: .NET, Vs2013, WCF
%d bloggers like this: