topic Re: [resolved] Connection failure to SQL Server in Installing and Upgrading

[resolved] Connection failure to SQL Server

Anonymous — Sat, 16 Nov 2024 10:43:27 GMT

I have version 6.1.1 of Talend Open Studio for Data Integration.
I can connect to my SQL Server database using SQL Server Management Studio, using SQL Server authentication (not Windows authentication)
When I try to use the same credentials in Talend (plus the name of a database), I get Connection failure error (connection refused).

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLException: Network error IOException: Connection refused: connect
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
... 12 more

Re: [resolved] Connection failure to SQL Server

Anonymous — Fri, 25 Mar 2016 02:30:31 GMT

Hi,
Are you connecting to sql server 2014?
So far, SQL Server 2014 is not list on the supported DataBase.
Please refer to document about:TalendHelpCenterupported systems databases and business applications by Talend components.

In the documentation we provide a list of databases that are supported, in the sense that we do provide an SLA and technical support for them. This doesn't mean other (non-listed) databases will not work but simply we won't necessarily be equipped to help you with any issue you may face with them.

Best regards
Sabrina

Re: [resolved] Connection failure to SQL Server

Anonymous — Fri, 25 Mar 2016 17:50:26 GMT

Thank you Sabrina. Is there any estimated release date for SQL Server 2014 support?

Re: [resolved] Connection failure to SQL Server

Anonymous — Mon, 28 Mar 2016 04:01:33 GMT

Hi,

Is there any estimated release date for SQL Server 2014 support?

Here is a jira issue:https://jira.talendforge.org/browse/TDI-32709
Can you successfully connect to sql server 2012 by using V 6.1.1 of Talend Open Studio for Data Integration?
Best regards
Sabrina

Re: [resolved] Connection failure to SQL Server

Anonymous — Mon, 28 Mar 2016 04:54:42 GMT

Thank you. I tried on a different environment that has sql server 2012 and got it working there.

Re: [resolved] Connection failure to SQL Server

Anonymous — Mon, 28 Mar 2016 08:23:04 GMT

Hi,
Feel free to let us know if there is any further help we can give.
Best regards
Sabrina

Re: [resolved] Connection failure to SQL Server

Anonymous — Thu, 28 Apr 2016 18:25:49 GMT

I am experiencing the same error with TOS MDM 6.1.1 and SQL 2008. What is the solution to this problem?
In the DB Connection Wizard form, the "Login and Password" is for what?

Re: [resolved] Connection failure to SQL Server

Anonymous — Fri, 29 Apr 2016 10:09:41 GMT

Hi,
We have replied to your another topic: https://community.talend.com/t5/Data-and-Metadata-Governance/resolved-TOS-MDM-6-1-1-Connect-string-to-a-SQL-Server-8-DB/td-p/83776. Could you please have a look at it?
Best regards
Sabrina

Re: [resolved] Connection failure to SQL Server

Anonymous — Wed, 27 Feb 2019 08:59:06 GMT

Hello,

Can you please show the database connection settings for MSSQL Server 2012 via a screen shot or tell what all connections you have while connecting MSSQL Server 2012?

Thank you in advance.

Re: [resolved] Connection failure to SQL Server

GORIOL1611658466 — Tue, 26 Jan 2021 11:24:31 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: [resolved] Connection failure to SQL Server

Anonymous — Thu, 28 Jan 2021 08:22:13 GMT

Hello Gaetan,

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