You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-08-27 15:10:11

naresh-ibaset
Member
3 posts

naresh-ibaset said:

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

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
mini_Error.png.png

Last edited by naresh-ibaset (2016-08-27 15:20:43)

Offline

#2 2016-08-29 03:20:25

xdshi
Talend Team


xdshi said:

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

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
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-08-29 05:36:15

naresh-ibaset
Member
3 posts

naresh-ibaset said:

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

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

Last edited by naresh-ibaset (2016-08-29 05:37:18)

Offline

#4 2016-08-29 07:41:50

xdshi
Talend Team


xdshi said:

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

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


What we can do is to make sure that Talend will be your best choice!

Offline

#5 2016-08-29 13:42:57

naresh-ibaset
Member
3 posts

naresh-ibaset said:

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

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

Thanks,
Naresh

Offline

#6 2016-08-30 09:56:35

xdshi
Talend Team


xdshi said:

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

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


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy