Network error IOException: Connection refused: connect

Scott Beeson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 30, 2015

This question is in reference to Atlassian Documentation: Database Setup for SQL Server

I am using the jtds drivers, version 2.2 as recommended.  I have a SQL Server 2012 Express installation.  I put the jar file in the confluence/lib folder and restarted the service.  Here are my settings:

Driver Class Name: net.sourceforge.jtds.jdbc.Driver
Database URL:  jdbc:jtds:sqlserver://localhost:1433/Confluence
User Name: *********
Password: **********

I have given my sql user every possible role for the Confluence database:

 

image2015-10-30 9:29:39.png

 

Yet I still get the following error:

image2015-10-30 9:27:19.png

The following error(s) occurred:

  • configuring.db.failed
  • java.sql.SQLException: Network error IOException: Connection refused: connect

1 answer

0 votes
Scott Beeson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 30, 2015

I changed the url to `jdbc:jtds:sqlserver://localhost:1433/Confluence;instance=./EXPRESS` and now I get a different error: `java.sql.SQLException: Unable to get information from SQL Server: localhost.`

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events