Setting Up Jira Service Desk to Microsoft SQL Server

Question

Hello,

I am having an issue getting Jira service desk connected to Microsoft SQL. I have SQL running on the same server as Jira. I have run through the setup wizard on the site however i am not having luck. The error i get is...

Jira - Jira setup

Error connecting to database

Login failed for user 'jira'. ClientConnectionId:3ca7ed60-f568-4a7e-9f50-98e3bb055036

I have given the user name jira rights to connect and owner of the db

I have also tried with windows authentication with a domain admin that has owner rights to the db as well but no luck.

Any Idea's what could be causing this?

THank You

Nick

Shannon S · Answer

Hi Nick,

Thank you for confirming that. Feel free to let us know here what you did to fix it, in case other users want to try using SQL Express 2017 in the future.

Keep in mind as well if your performance gets too bad, please consider moving to a supported database.

For the SSL, I would recommend starting with the following article:

* Running Jira Applications over SSL or HTTPS

If you get stuck, please raise a new question on Community so we can help you there.

Regards,

Shannon

Nicholas Chiaffarelli · Answer

Looks like i got it to work on SQL 2017. Next step is getting this to be on SSL. How would i be able to do that?

Thank You,

Nick

Shannon S · Answer

Hi Nick,

SQL Server 2017 is not supported in Jira, nor are any of the Express versions.

Have a look at Supported Platforms for more information:

Microsoft SQL Server:

* Jira will not work on:* Express Editions of Microsoft SQL Server

* Supported Microsoft SQL databases use the Microsoft JDBC 6.2.1 Driver.

Supported versions are:

* SQL Server 2016
* SQL Server 2014
* SQL Server 2012

Support for SQL Server 2017 is in progress on this feature request:

* JRASERVER-66320

I can say that I have heard of users setting up Jira successfully on SQL Server Express versions, but it can cause many performance issues, so I don't recommend it.

If you don't want to commit to the full version of SQL, I would recommend setting up Jira using Postgres or MySQL which are free and supported.

Let me know if you have any questions!

Shannon