title: Entity Framework connection work locally but not on remote server after deploy
body: <p>I have created a web application in ASP.NET MVC using a SQL Server database, and I used Entity Framework with a database-first approach.</p>
  
  <p>This is my connection string for Entity Framework</p>
  
  <pre><code>&lt;add name="AcModelFinalContext" 
       connectionString="metadata=res://*/Models.Maha-Earth-Model.csdl|res://*/Models.Maha-Earth-Model.ssdl|res://*/Models.Maha-Earth-Model.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=DESKTOP-IE0U7PA\SQLEXPRESS;initial catalog=AC-Services;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" 
       providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>This connection string is working fine on localhost.</p>
  
  <p>For deployment I made made changes in string as</p>
  
  <pre><code>&lt;add name="AcModelFinalContext" 
       connectionString="metadata=res://*/Models.Maha-Earth-Model.csdl|res://*/Models.Maha-Earth-Model.ssdl|res://*/Models.Maha-Earth-Model.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=dburl.com\SQLEXPRESS;initial catalog=AC-Services;integrated security=True;User Id=mydb;Password=mypass;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" 
       providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>but this does not work.</p>