Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,116
Community Members
 
Community Events
168
Community Groups

Jira Datacenter no longer able to connect to SQL Server

Edited

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.

1 answer

0 votes
edwin vasquez Community Leader Aug 08, 2022

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

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events