We are having problems trying to deploy a .NET 4 app. that use Data Entity Framework on our production server. The app work locally with SQL Server 2008 R2. but won't connect to the SQL Server 2005 on the production server.
The connection string used on the local system (with SQL server 2008) is as follow:
<add name="targaVC2Entities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=utilisateur-pc;initial catalog=targaVC2;integrated security=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
We sent many hours trying to run this app. on our production server without success.
We can reach a simple 'about' page but any attemps to reach a page which try to connect to the DB fails.
Any idea what needs to be modified in the connection string to solve this problem ?
Or any idea about the source of the problem ? (SQL 2005 config ? Compatibility issue ? anything else ... ?
Thank you for your help.