MS SQL database TLSv1 error.

Stephen Ralston
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 19, 2019

Can't reach database server or port

I keep getting the following error.  

SQLState - 08S01
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server chose TLSv1, but that protocol version is not enabled or not supported by the client.". ClientConnectionId:adaa0274-9e6c-48a4-97bd-4e0652dc80bd

 

I can telnet into the server.  Also, I tried to add the JDBC 7.0 driver.

https://community.atlassian.com/t5/Confluence-questions/Confluence-6-10-1-Server-Install-Error-connecting-to-MSSQL-DB/qaq-p/863461

It is a new install upgraded to 7.10.  

1 answer

1 accepted

0 votes
Answer accepted
Mark Bereznitsky
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 19, 2019

Hello @stephen ralston ,
With 7.1.0, we added system properties that restrict the HTTP clients to use TLSv1.1 and TLSv1.2 only as TLSv1 is getting phased out and is considered insecure.

If you still want to enable it, use this guide to edit the JVM arguments:

https://confluence.atlassian.com/adminjiraserver/setting-properties-and-options-on-startup-938847831.html

 

Find the one that says:

 

-Djdk.tls.server.protocols=TLSv1.1,TLSv1.2 -Djdk.tls.client.protocols=TLSv1.1,TLSv1.2

 

and prepend "TLSv1" to both lists (with a comma as well). Restart Confluence and it should word. But again, consider migrating to a newer version that is more secure. 

Lei Wang
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 27, 2019
Like Mark Bereznitsky likes this
xiaozhugu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 28, 2024

I didn't see this service,4.png

What should I do?

Lei Wang
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 19, 2024

Hey @xiaozhugu ,

How was the Confluence installed in Windows? Using installer.exe? What is the version of the Confluence you are using?

 

Best Regards,

Lei

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events