title: What is the correct syntax for a Flyway connection string to SQL Server?
body: <p>Running SQL Server 2012 Express on a remote machine, trying to get Flyway up and running. I have a database on <code>pcesqldev.pce.local</code> called <code>Hawk</code> (<code>dbo.Hawk</code>, if that matters) that I want to connect to, and the template from the config file looks like this:</p>
  
  <pre><code>SQL Server        : jdbc:jtds:sqlserver://&lt;host&gt;:&lt;port&gt;/&lt;database&gt;
  </code></pre>
  
  <p>Note, this is different from other jdbc connection strings I have used with other products - most of them do not include the jtds portion and do include the instance name.</p>
  
  <p>Here's a few connection strings that I have tried, all of which failed:</p>
  
  <ul>
  <li><pre><code>flyway.url=jdbc:jtds:sqlserver://pcesqldev.pce.local:1433/Hawk
  </code></pre>
  
  <blockquote>
    <p>Network error IOException: Connection refused: connect</p>
  </blockquote></li>
  <li><pre><code>flyway.url=jdbc:jtds:sqlserver://pcesqldev.pce.local\SQLEXPRESS:1433/Hawk
  </code></pre>
  
  <blockquote>
    <p>Unknown server host name 'pcesqldev.pce.local\SQLEXPRESS'</p>
  </blockquote></li>
  <li><pre><code>flyway.url=jdbc:jtds:sqlserver://pcesqldev.pce.local/SQLEXPRESS:1433/Hawk
  </code></pre>
  
  <blockquote>
    <p>Network error IOException: Connection refused: connect</p>
  </blockquote></li>
  <li><pre><code>flyway.url=jdbc:jtds:sqlserver://pcesqldev.pce.local:1433/SQLEXPRESS\Hawk
  </code></pre>
  
  <blockquote>
    <p>Network error IOException: Connection refused: connect</p>
  </blockquote></li>
  </ul>
  
  <p>What am I missing? There must be something obvious, but I can't see it.</p>
  
  <p>Before anybody asks, yes we do have TCP access to the database enabled and it is using port 1433.</p>