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

Compatibility with SQL Server 2017

We want to upgrade our JIRA databases to the new SQL Server 2017 instance for better availibility and performance at our company. Is there any planning regarding support of SQL Server 2017 for newer versions of JIRA in future? Can we wait for a new version release which will be compatible with SQL Server 2017 database?

6 answers

1 accepted

1 vote
Answer accepted

Hey Kanan,

Unfortunately none of the JIRA versions support MSSQL Server 2017 as of yet.

There's a suggestion ticket opened in our system already. Please add yourself as a watcher and vote the issue for it to have more visibility. Being a watcher on a ticket means that you will get notified by all the updates posted on the ticket so you can follow the progress done on the ticket.

Here is the link for the suggestion ticket opened.

Thanks in advance.


Thanks very much, Martin. I have added a vote and watching these issues from now. I hope the priority of these tickets will be raised as soon as possible, because "Low" priority is not the level of this type of problems.

Please, any update on this? SQL Server 2017 is needed!

Do you have a timeframe for when SQL Server 2017 support is coming?
I see with the 7.9 release in April SQL Server 2016 support was added

Realting to Peter's post, I also want to know the support date for SQL Server 2017.

We have just updated to a MS SQL 2017 and want to install JIRA for the first time.

There's a hack to run SQL Server 2017 in Compat mode.

It isn't supported though, meaning if anything goes wrong, you can dig down deep into JIRA and debug it yourself :/

@Martin Orzaiz There is posibility to run SQL server 2017 witch 2014 combatibility mode. Will this configuration works properly?

My company migrate to SQL 2017 and i wonder if i have to maintain one serwer in 2014 and second in 2017 OR can i migrate to SQL 2017 wich 2014 compatibility mode?

It will probably work.  But it will NOT be supported, so we can't recommend that you do it.

You'd need to spin up a new test instance on 2017, alter the compatibility level to 2014, then perform rigorous testing of the entire application, workflows and plugins. Don't forget attachments and mail handlers.

(This is also why it takes time for vendors to give the all clear).

P.S. SQL 2019 is around the corner, but still who is game to go with v1 of MSFT SQL.

Hi any updates on this?

We have JIRA v7.7.0 and JIRA Service Desk Application v3.10.0 running on Windows server 2016 and SQL 2014 

and would like to upgrade to 

Server 2019  and SQL 2017 

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Thursday in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

111 views 0 10
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you