You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
Team,
We have installed JIRA Software Server 8.12.2 and in the instance health, I'm getting an alert that, the database server version is not supported - SQL Server 2014.
We have created database from Azure SQL. Do we have any timeline from JIRA for the database upgrade?
Thanks,
Prasenna
Atlassian haven't supported SQL Server 2014 for their products for quite a while.
It does, as far as I can tell, work ok for Jira 8.x, but it is unsupported, and you should upgrade it to a supported version as soon as you can. 2016 and 2017 are supported as the databases for Jira 8.12, so I would recommend upgrading to 2017 for a bit more future-proofing.
Thanks!
While installing the JIRA Software Server, I did look into the specification here - https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html
For Azure SQL, there were no details provided and now I'm getting an instance error as unsupported, for PaaS we don't have a control, why the JIRA is prompting for instance health failure?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, so this is going to sound bad or grumpy, but I am trying to avoid a rambling essays:
You have found and read exactly the right documentation that you should. And you've not just followed it by rote, you have understood it too.
So why have you installed an old and unsupported database at the back end? Azure can provide supportable databases, is there a good reason to use a "legacy" one?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, and you've used the wrong one. Why did you ignore the supported versions doc you read?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, it is, when you use a supported database on it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SQL in Azure, comes in 3 flavours ... only PaaS is in question referenced by Atlassian documentation:
- SQL Server 20XX on a VM (Infrastructure as a Service, IaaS as the OP mentioned earlier)
- SQL Managed instance, similar to above but MSFT take care of the cluster for you
- SQL Platform as a Service (PaaS) < also referred to as 'Azure SQL'.
I noticed the same issue that OP is seeing when we upgraded from DTU tier to vCore tier. There is of course no change to the version of the SQL and only the performance should be affected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.