Jira Datacenter no longer able to connect to SQL Server

[Michael Luck]

EDIT: Figured it out, was related to our SQL server updating in combination with JRE 11 that uses encryption by default. In dbconfig.xml we added ";encrypt=false" to the end of our database URL to force encryption back off and all is well again. Hope this may help someone in the future.

Hello,

Kinda stumped on this issue, it started recently after a SQL server update was installed onto our Jira server. We run on SQL Server 2016 and it is installed locally on the same server we hava Jira installed. These are the errors I am seeing in the log (pasted below). We never set up encryption on our SQL server, is there a way to tell Jira to stop trying to use SSL? Thank you

com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:d10320f7-61c4-4832-8e75-aacaa3cd5cb1

Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(Unknown Source)
at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source)
at java.base/java.security.cert.CertPathBuilder.build(Unknown Source)
... 57 more
2022-08-08 13:22:56,359-0400 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] JIRA couldn't connect to your database
2022-08-08 13:22:56,359-0400 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] JIRA failed to establish a connection to your database.
This could be because:
- Your database isn't running
- The configuration of your dbconfig.xml file is incorrect (user, password, or database URL etc.)
- There is a network issue between JIRA and your database (e.g. firewall, database doesn't allow remote access etc.)

There are several other solutions you can try, review our documentation and see what works for you.

[edwin vasquez]

Thanks for sharing your solution. Im sure this will help someone out in the future.