How to use built in JDBC driver for SQL Server

[Zutari GEMC3 Admin]

I am having problems with connecting to SQL Server DB. I have installed the latest JIRA Software Server 8.2, but when starting Jira in browser it gives me an error that database driver is not found.

According to my understanding you don't need to manually install a driver for SQL Server? How can I use the built in JDBC driver that comes with Jira?

Would appreciate help and advice. Thank you.

[Zutari GEMC3 Admin · Accepted solution]

I eventually had to use the "mssql-jdbc-7.2.2.jre8.jar" driver that I had to download from Microsoft and this did the trick. All working fine now. (I also tried the "mssql-jdbc-7.2.2.jre11.jar" driver but this still gave the error, I had to delete it and use only the jre8 driver, then it worked.)

[MoroSystems Support]

Hi Aurecon,

What SQL server are you using?

JIRA 8.2 suppported only MySQL, PostgreSQL, Oracle and MSSQL - https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html

If you use MSSQL and PostgreSQL, you do not need to install the JDBC driver.

If you use Oracle and MySQL, you need imanually install JDBC driver to JIRA.

Install Oracle JDBC - here is the manual - https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-oracle-938846856.html

Install MySQL JDBC - here is the manual - https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-6-938846854.html

Have a nice day.

[Zutari GEMC3 Admin]

Thank you for your response. We are using SQL Server 2017.

I also understand that I don't need to install the JDBC driver, but yet it gives me an error that the DB driver is not found. So how can I tell it to use the built-in SQL Server driver?