Database connection issue when deploy on IIS

Question

I have configured 2 connections strings :

  <connectionStrings>
    <add name="ApplicationServices" connectionString="Data Source=.\SQLInstance;Initial Catalog=App;Integrated Security=True" providerName="System.Data.SqlClient"/>
    <add name="AppEntities" connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLInstance;Initial Catalog=App;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient"/>
</connectionStrings>

The project is running well when launched from VS.But deployed on IIS, I get "data source keyword not supported" when try to get entities. Membership (so the ApplicationServices connection) works.

Can someone help me to solve this problem ?

Edit : the problem is the same if we use application or web site

Are you sure you are using the second connection string in EF not the first? — Arsen Mkrtchyan
– Arsen Mkrtchyan, Commented May 18, 2011 at 7:13
Try to remove the first connection string, and check what will happen in visual studio and in IIS — Arsen Mkrtchyan
– Arsen Mkrtchyan, Commented May 18, 2011 at 19:40
Nothing work . EF use the good connection string: public AppEntities() : base("name=AppEntities", "AppEntities") { this.ContextOptions.LazyLoadingEnabled = true; OnContextCreated(); } — Fx59
– Fx59, Commented May 21, 2011 at 7:18

Fx59 · Accepted Answer · 2011-06-04 13:48:40Z

3

I finally found the solution. Connection string are not read from IIS configuration but from the web.config.

When create the deployment package, VS do some magic with web.config because it read from web.release.config. When inspected the generated config file, I have remark thaht " have been replaced by ".

So the generated connection string is not valid and we should replace manually & by &.

Thank you anyway for your help

answered Jun 4, 2011 at 13:48

Fx59

611 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Deltax76 · Accepted Answer · 2011-05-18 14:04:17Z

1

You have to install .NET framework 3.5/4.0 on the server, and then set your web application to use it , then IIS should be able to recognize Entity Framework connection string

Edit: enter image description here

edited May 18, 2011 at 14:04

answered May 18, 2011 at 7:24

Deltax76

14.3k34 gold badges98 silver badges129 bronze badges

3 Comments

Fx59 Over a year ago

.Net framework is installed. We have install visual studio on the server (virtual machine for test). When running with vs (build & run), all is good. When running from IIS (after deployment thanks vs), it's possible to login.But impossible to retrieve data : we got the error.

Deltax76 Over a year ago

I assume that you're using .NET 4.0 on IIS 6.x. As I said, you have to config IIS to allow your web application to use properly version. Right click on your web app in IIS, choose property, in ASP.NET tab, set version to .NET 4.0 :). That should work

Fx59 Over a year ago

We use II 7 with .NET 3.5.1. The application pool is running in v4

Collectives™ on Stack Overflow

Database connection issue when deploy on IIS

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related