title: web.config connectionStrings on production server
body: <p>I'm attempting to deploy my first website containing a database. The test local version has the following connection strings</p>
  
  <pre><code>&lt;connectionStrings&gt;
     &lt;add name="ApplicationServices" 
          connectionString="data source=.\SQLEXPRESS;IntegratedSecurity=SSPI;
                            AttachDBFilename=|DataDirectory|\aspnetdb.mdf;
                            User Instance=true"
          providerName="System.Data.SqlClient" /&gt;
     &lt;add name="ConnectionString" 
          connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\AHData.mdf;IntegratedSecurity=True"
          providerName="System.Data.SqlClient" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I've setup the databases on the web hosting company server and they give me the following connections strings</p>
  
  <pre><code>Provider=sqloledb;Data Source=db479427514.db.1and1.com,1433;Initial Catalog=db479427514;User Id=dbo479427514;Password=****;
  
  Provider=sqloledb;Data Source=db479427535.db.1and1.com,1433;Initial Catalog=db479427535;User Id=dbo479427535;Password=****;
  </code></pre>
  
  <p>When I replace the local test connection strings with the new server ones using </p>
  
  <pre><code>&lt;connectionStrings&gt;
     &lt;add name="ApplicationServices" 
          connectionString="Provider=sqloledb;Data Source=db479427535.db.1and1.com,1433;Initial Catalog=db479427535;User Id=dbo479427535;Password=**I've used real password!**;"
          providerName="System.Data.SqlClient" /&gt;
  
     &lt;add name="ConnectionString" 
          connectionString="Provider=sqloledb;Data Source=db479427514.db.1and1.com,1433;Initial Catalog=db479427514;User Id=dbo479427514;Password=**I've used real password!**;"
          providerName="System.Data.SqlClient" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I get the following error</p>
  
  <blockquote>
    <p>Keyword not supported: 'provider'.</p>
    
    <p>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. </p>
    
    <p>Exception Details: System.ArgumentException: Keyword not supported: 'provider'.</p>
    
    <p>Source Error: </p>
    
    <p>An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</p>
    
    <p>[ArgumentException: Keyword not supported: 'provider'.]  </p>
    
    <p>[ArgumentException: An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax.<br>
    Parameter name: connectionString]</p>
  </blockquote>
  
  <p>Can anyone advise what is wrong here?</p>