title: connecting to sql server with jdbc error
body: <p>I'm trying to connect to a sql server via the jdbc driver but keep getting this error:</p>
  
  <blockquote>
    <p>Error connecting to the specified data source: The TCP/IP connection
    to the host localhost, port 1433 has failed. Error: "Connection
    refused: connect. Verify the connection properties. Make sure that an
    instance of SQL Server is running on the host and accepting TCP/IP
    connections at the port. Make sure that TCP connections to the port
    are not blocked by a firewall.".</p>
  </blockquote>
  
  <p>My connection string is this:</p>
  
  <pre><code>jdbc:sqlserver://localhost\SRVR_SQL:1433;DatabaseName=spotfire_server    
  </code></pre>
  
  <p>I've also tried this:</p>
  
  <pre><code>jdbc:sqlserver://10.10.60.12\SRVR_SQL:1433;DatabaseName=spotfire_server    
  </code></pre>
  
  <p>and this:</p>
  
  <pre><code>jdbc:sqlserver://localhost:1433;DatabaseName=spotfire_server   
  </code></pre>
  
  <p>and this:</p>
  
  <pre><code>jdbc:sqlserver://SRVR_SQL:1433;DatabaseName=spotfire_server   
  </code></pre>
  
  <p>but all of them give the same error</p>