Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GORIOL1611658466
Contributor
Contributor
‎2021-01-26 08:30 AM

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

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

106 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2021-01-28 03:21 AM

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

106 Views
0 Likes