How to setup Jira with Microsoft SQL Server

[Marcel Heelein]

Good Day Everyone,

I have been attempting to setup Jira Service Desk to interface with our Microsoft SQL Server (2017).

I understand MSSQL 2017 is not Officially supported.

I am facing the issue of JIRA not even wanting to connect to the DB Server, I checked firewalls, connections, ports, everything possible. The database is setup to support v2014.

The Error: [The TCP/IP connection to the host [INTERNAL IP HERE], port 1433 has failed. Error: "Connection refused: no further information.]

I have checked log files, they all describe the same error, without further information.
I can assure you the SQL server is reachable, the correct usernames and passwords were entered, and the Database is setup correctly. I got Confluence to work with it flawlessly on the first try! But Jira Service Desk is puking up errors and I cant seem to find a solution or assistance regarding this topic.

Also this SQL Server is hosted on a Instance, which I was able to input in the Database Connection field of the Confluence installation, but NOT the Jira Application.

I am desperately looking for support, I'd really love to start using Jira at our Company nationwide, this is supposed to be our small scale test, which isn't going very well sofar :(

If anyone has setup Jira with Microsoft SQL 2017 and has it up an running, kindly help a sysadmin out :)

Thanks!

[Alexis Robert · Accepted solution]

Hi @Marcel Heelein, 

can you first check that the server where you want to install Jira has access to your SQL Server instance ? You can test this with telnet:

telnet my.database.ip 1433

This should at least confirm that there are no network issues.

Can you also check what port SQL Server is using ? As you have a named instance, port could be different from the standard 1433.

If this is the case, you don't need to set the instance name in the connection string and will only need to update the port number in the Jira setup page.

Let me know if this helps, 

--Alexis

[Marcel Heelein]

Holy smokes, adjusted the port specific to the Instance and it worked!
Thank you for your quick assistance!

You the MVP!

[Xavier Morera]

A problem that I keep running into is that JIRA requires a port, but SQL Server is installed with Dynamic Ports, which Confluence doesn't care about as it does not need a port.

So how can I install Jira when SQL Server has a dynamic port?