Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
We are facing the same issue with our job since 19th december 2020. ALL jobs worked perfectly before. Our error message is :
Network error IOException: Connection refused: connect
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
It happens most of the time during the night and some job running well if we launch it during the day...
Our configuration is sql server 2012 and Talend Studio 7.1.1 studio for devloppement.
Thanks for your help.
Gaetan
Hello,
It seems that errors are a result of firewall setting that prevents outbound connections from the job server to the MS SQL Server host machine.
Could you please try to tweak firewall to allow outbound connections to the database server that the job needs to connect to? Let us know if it works.
Best regards
Sabrina