Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to setup Jira with Microsoft SQL Server

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!

 

1 answer

1 accepted

2 votes
Answer accepted
Alexis Robert Community Leader Jul 02, 2018

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

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

You the MVP!

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?

Like Andre Neiber likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,326 views 22 31
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you