topic Re: Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio in Data Quality

Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio

Anonymous — Sat, 16 Nov 2024 10:25:47 GMT

Hi,
I am not able connect to Microsoft SQL Server 2008 R2. I am using Talend Studio Enterprise edition 6.1.1, I have tried create database connection with all required details but error popups that "You Must Change Database Settings".
I am using SQL Server Authentication mode while connecting to database.
Does it require any pre-configuration on Talend side or Database Side?
What about Additional Parameter in connection dialog box?
Thanks,
Naresh

Re: Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio

Anonymous — Mon, 29 Aug 2016 03:20:25 GMT

Hi,
Can you successfully connect your Microsoft SQL Server 2008 R2 by client without using talend tool?
Could you please click "Details>>" to see if there is any more error message about your connection issue?
Best regards
[font=Verdana, Helvetica, Arial, sans-serif] Sabrina[/font]

Re: Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio

Anonymous — Mon, 29 Aug 2016 05:36:15 GMT

Hi,
Yes, I can connect to SQL Server 2008 R2 using client.
Please find attached error message which you have requested from "Details" tab.

Error Message
___________

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

Thanks,
Naresh

Re: Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio

Anonymous — Mon, 29 Aug 2016 07:41:50 GMT

Hi,
Are your Talend Studio and SQL Server running on the same computer? If so, please try "localhost" as value for "Server" to see if it works.
Best regards
Sabrina

Re: Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio

Anonymous — Mon, 29 Aug 2016 13:42:57 GMT

Hi,
Talend Studio and SQL Server installed on separate machine.

Thanks,
Naresh

Re: Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio

Anonymous — Tue, 30 Aug 2016 09:56:35 GMT

Hi,

Talend Studio and SQL Server installed on separate machine.

Please use IP instead of "VMSRV-ORATEAM" to see if it works.
Best regards
Sabrina

Re: Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio

msjian — Wed, 08 Jan 2020 09:25:38 GMT

it is Network error IOException: Connection refused: connect, please check network or input parameters

Regards
Jian
----------------------------------------------------------
Talend | Data Quality