MSSQL 2012 Connection refused: connect at net.sourceforge.jtds.jdbc.JtdsConnection

GORIOL1611658466 — Sat, 16 Nov 2024 00:45:25 GMT

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

Re: MSSQL 2012 Connection refused: connect at net.sourceforge.jtds.jdbc.JtdsConnection

Anonymous — Thu, 28 Jan 2021 08:21:24 GMT

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

topic MSSQL 2012 Connection refused: connect at net.sourceforge.jtds.jdbc.JtdsConnection in Installing and Upgrading

MSSQL 2012 Connection refused: connect at net.sourceforge.jtds.jdbc.JtdsConnection

Re: MSSQL 2012 Connection refused: connect at net.sourceforge.jtds.jdbc.JtdsConnection