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-09-28 09:07:03

CSchlederer
Member
2 posts

CSchlederer said:

Cant connect to MSSQL Server using SQL User (Data Integration)

I've tried to connect to a MS SQL Server per Talend Open Studio for Data Integration but nothing works, with SQL Server Management Studio it works well to connect with the user. hmm
Please help me!
I get that error:
Verbindung fehlgeschlagen. Sie müssen die Datenbankeinstellungen ändern.
  java.lang.RuntimeException: java.sql.SQLException: Login timed out.
      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:315)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$46.runWithCancel(DatabaseForm.java:3173)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$46.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: Login timed out.
      at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:433)
      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.SocketTimeoutException: connect timed out
      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

How can i fix that?

Offline

#2 2016-09-28 10:46:13

xdshi
Talend Team


xdshi said:

Re: Cant connect to MSSQL Server using SQL User (Data Integration)

Hi,
What's Talend Open Studio for Data Integration build version you are using? Would you mind sharing your MSSQL DB connection setting screenshot with us? Is your sql server DB on local or remote?
The network is Ok with you?
Best regards
Sabrina


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

Offline

#3 2016-09-28 11:22:38

CSchlederer
Member
2 posts

CSchlederer said:

Re: Cant connect to MSSQL Server using SQL User (Data Integration)

I'm using Version 6.2.1.20160704_1411,


this is my mssql db connection setting, 

the server is on remote,

all network functions are working and i can go with the user inside the database per SQL Server Management Studio.

mini_2016-09-28_12h25_29.png.png

here is the database on the server:


mini_2016-09-28_12h27_28.png.png

Last edited by CSchlederer (2016-09-28 11:29:26)

Offline

#4 2017-01-25 19:55:47

vasu0975
Member
1 post

vasu0975 said:

Re: Cant connect to MSSQL Server using SQL User (Data Integration)

Hi,
Can Some one share the solutions for the above issue as i'm facing the same.

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy