Hi,
I am currently working on WPF project that uses SQLEXPRESS 2012 DB and EF 5.0.
I was able to connect to the DB when it was hosted on the same PC. I now hosted the DB to a differernt PC and trying to access it through WPF app, but getting the error as "The underlying provider failed to open". I went through various forums
to fix the issue but none of the solutions provided resolved the issue. Below is my connection string
<add name="SAPActivityContext" connectionString="metadata=res://*/SapEntity.csdl|res://*/SapEntity.ssdl|res://*/SapEntity.msl;provider=System.Data.SqlClient;provider connection string="data source=192.168.0.100\SQLEXPRESS;initial
catalog=Sap;persist security info=True;user id=sa;password=Pass@word7;MultipleActiveResultSets=True;"" providerName="System.Data.EntityClient" />
The connection string has been refactored based on the various inputs provided i ...
Go to the complete details ...