ETL Talend job is getting failed due to "Child job running failed. com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrow

Question

Hello, ETL job is getting failed due to **"**Child job running failed. com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing"." We have check with the execution server network team and they said the connection reset from client( database server). They monitor the traffic on their side and shared the screenshot. Can anyone help us resolving this error. Regards, Abhishek Tehra

Answer 1

Hi
TEHRA Abhishek (External) •

As I understand, looks like you are facing issue in connecting to Azure SQL Database from Talend.

Please refer to the link https://community.qlik.com/t5/Design-and-Development/Connecting-Talend-to-Azure-SQL-Database/td-p/2348518 which has given the steps for connection.

If you face issue, please raise question over Qlik(Talend) community forum so that concerned team can help you.

Thanks

Answer 2

Hi
TEHRA Abhishek (External) •

Thanks for the details.

I think you should connect to the Azure SQL database team who has configured it, maybe some network settings have been changed.

Please check with them and share more details about the DB.

Thanks

Answer 3

Hi
TEHRA Abhishek (External) •

Thaks for sharing update.

It looks like transient Network issue.

Thanks