title: web.config connection string to different database server
body: <p>I have two conn strings in my web.config
  The second of them connects to external database - the database is on different server than the current website.</p>
  
  <ol>
  <li>Is it possible?</li>
  <li>How do I write my connection string?</li>
  </ol>
  
  <p>I have this now:</p>
  
  <pre><code>&lt;add name="newConn" connectionString="server=www.somedomain.com;database=dbname;user id=dbuser;password=dbpass" providerName="MySql.Data.MySqlClient" /&gt;
  </code></pre>
  
  <p>But I'm getting error saying:</p>
  
  <p><em>Access denied for user 'dbuser'@'currentdnsserver.com' (using password: YES)</em></p>
  
  <p>Thanks</p>