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

[Anonymous]

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

[Anonymous]

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]

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

Thanks,
Naresh

[Anonymous]

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

[msjian]

Hi

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

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