This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 69%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Hi Guys,
I am connecting Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64) from RHEL9.6 system having openJDK17 on it but getting below error. I tried with SQL driver version 13,12 and 10 but result is same always. So can you please suggest the fix and correct SQL driver version to work with OpenJDK17 and MSSQL 2008 R2
[ ConnectorException ] [ Error details ] The server encountered an unexpected error while contacting target system. Please check the logs. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:4c46e372-53d1-4456-92cd-ea1cb44b6b08".
That certainly sounds like a TLS problem. That build of SQL 2008 R2 should support TLS 1.2, but what about the operating system SQL Server is running on?
It is worth mentioning that SQL Server 2008 R2 did not originally support TLS 1.2, and nor was TLS 1.2 support included in SP3, the last service pack (as TLS 1.2 was not yet defined by then), but this came in a later build. The version number you post is beyond that point, but you may want to double-check.
Thank you @Erland Sommarskog for your reply.
Is there any driver which is compatible with OpenJDK17 and Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64)?
Unfortunately, I don't work in the Java space, and I am not at familiar with OPENJDK, so I cannot answer. But I think you should the OS of the SQL Server machine.
JDBC driver is developed on java platform (JDK or openJDK) so my questions - is there any JDBC driver for MSSQL 2008 R2 which works on JDK17 platform and connects successfully to MSSQL as well.
As I said, I don't do Java. But if you find a driver old enough it may support TLS 1.0. But TLS 1.0 is highly insecure. It would be better to try to patch Windows to support TLS 1.2.
By the way, are you able to connect to the SQL 2008 R2 instance with a remote SSMS?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Hi Sumit Chaudhary,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? Is your issue resolved? or let us know if you need any further assistance.
Thanks,
Anjan Kumar Chippa
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more