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

Highlighted
One Star

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
Moderator

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
[font=Verdana, Helvetica, Arial, sans-serif]Sabrina[/font]
--
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: 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
Moderator

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
--
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: Not able to connect to Microsoft SQL Server 2008 R2 - Talend Studio

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

Thanks,
Naresh
Moderator

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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read