Five Stars

[resolved] Connection failure to SQL Server

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
1 ACCEPTED SOLUTION

Accepted Solutions
Five Stars

Re: [resolved] Connection failure to SQL Server

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

Re: [resolved] Connection failure to SQL Server

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:TalendHelpCenterSmiley Frustratedupported 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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: [resolved] Connection failure to SQL Server

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

Re: [resolved] Connection failure to SQL Server

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: [resolved] Connection failure to SQL Server

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

Re: [resolved] Connection failure to SQL Server

Hi,
Feel free to let us know if there is any further help we can give.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Connection failure to SQL Server

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?
Moderator

Re: [resolved] Connection failure to SQL Server

Hi,
We have replied to your another topic:https://www.talendforge.org/forum/viewtopic.php?id=49509. Could you please have a look at it?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.