title: ASP.NET System.Data.EntityClient connection string help
body: <p>I'm running ASP.NET MVC on a shared server and I'm having problems connecting to SQL via System.Data.EntityClient.  Below is the connection string that my hosing provider gave me to connect to SQL and the one that VS configured for my local machine during development, what should my connection string look like when I deploy to the server?</p>
  
  <p>From my hosting provider:</p>
  
  <pre><code>&lt;add name="WeddingsDBEntities" 
    connectionString="data Source=&lt;server name&gt;; Initial Catalog=&lt;db name&gt;; User ID=&lt;user ID&gt;; Password=&lt;password&gt;;" 
    providerName="System.Data.EntityClient"/&gt;
  </code></pre>
  
  <p>From VS (during development):</p>
  
  <pre><code>connectionString="metadata=res://*/Models.WeddingsModel.csdl|res://*/Models.WeddingsModel.ssdl|res://*/Models.WeddingsModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\WeddingsDB.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"
  </code></pre>
  
  <p>Thanks!</p>