Network error IOException: Connection refused: connect

[Scott Beeson]

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

[Scott Beeson]

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.`