title: Debugging a connection string
body: <p>I've a website that works fine in local mode with local SqlExpress. When I publish and put the final server connection string, I keep getting the helpless <code>500 - Internal server error</code>. </p>
  
  <p>I tried to use the final server connection string in local debug mode, but even then it uses local SqlExpress instance, I don't know why! So again it is of no use. Here's the connection string:</p>
  
  <pre><code>&lt;add name="MainDbContext" connectionString="Data Source=rose.arvixe.com;Initial Catalog=mydb;Persist Security Info=True;User ID=myuser;Password=mypassword" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>I use these infos to connect to the server with Management Studio and it works fine. </p>
  
  <p>Is it possible to at least get a clear error message?</p>
  
  <p>After 7 hours on this problem, I beg for help.</p>
  
  <p>EDIT: If I remove all data acces from the page, it works. As soon as I'm creating a context, the error occurs. </p>