title: The underlying provider failed on Open iis
body: <p>I am working on asp.net web api, when I run my project on micro soft visual studio built in server every thing work fine, but when i host it on local iis server, I got the following error</p>
  
  <p><strong>The underlying provider failed on Open</strong></p>
  
  <p>I am using entity framework, my connection string in web.config is</p>
  
  <pre><code>&lt;add name="Entities" connectionString="metadata=res://*/Models.School.csdl|res://*/Models.School.ssdl|res://*/Models.School.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=.\sqlexpress;initial catalog=DBName;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>