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 2015-10-21 19:13:29

evanbossett
Member
2 posts

evanbossett said:

SQL Server Connection failure. java.sql.SQLException: Login timed out

Tags: [database, error, mssql]

I am unable to connect to my SQL Server 2008 database from Talend Open Studio for Data Quality (6.0.1.20150908_1633)
The error message i get is "SQL Server Connection failure.  java.sql.SQLException: Login timed out"
I can connect to Oracle with no problems.
I am able to connect to the SQL Server database remotely via Management Studio, so i don't think it's a connectivity or firewall issue.
Any suggestions?

Offline

#2 2015-10-22 04:24:45

xdshi
Talend Team


xdshi said:

Re: SQL Server Connection failure. java.sql.SQLException: Login timed out

Hi evanbossett,
Usually there are two ways to connect to sqlsever: sql server authentication and windows authentication.
Your SQL Server and Windows Authentication mode is enabled? Did you set up your DB connection in metadata or just use tMSSqlXXX component?

Best regards
Sabrina


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

Offline

#3 2015-10-22 13:38:47

evanbossett
Member
2 posts

evanbossett said:

Re: SQL Server Connection failure. java.sql.SQLException: Login timed out

thank you for commenting. my SQL Server 2008 has "SQL Server and Windows Authentication" enabled.  i have tested the user account by logging in from SQL Server Management studio.
I am trying to connect via the Talend GUI. 
After launching Talend Open Studio for Data Quality, i open the "DQ Repository" tab
Then Metadata -> DB Connections -> Create DB Connection
I give it a "Name", "Purpose", and "Description" and select "NEXT"
If i select "SQL Server 2005/2008" from the dropdown, my "Db Version" dropdown is empty and grey
string of connection = jdbc:sqlserver://MyServer:1433;DatabaseName=myDataBase
When i press "Check", the popup says "Connection Failure. You must change the Database Settings"
If i go to DETAILS>> i think i get a "Missing JDBC Driver" error <?>

  org.talend.utils.exceptions.MissingDriverException: can not find class :com.microsoft.sqlserver.jdbc.SQLServerDriver
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1117)
      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)


If i try the DB Type "Microsoft SQL Server" from dropdown and fill in my information, i get a "Login Timed Out" error
string of connection= jdbc:jtds:sqlserver://MyServer:1433/myDataBase;

Offline

#4 2015-11-04 11:33:51

Dutta
Guest

Dutta said:

Re: SQL Server Connection failure. java.sql.SQLException: Login timed out

I am facing the same problem with mysql connection.
My community edition is running fine but enterprise edition has problem
Something like that

Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:164)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1054)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:311)
      at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$26.runWithCancel(DatabaseForm.java:2335)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$26.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.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.net.URLClassLoader.findClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:90)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:115)
...

Please help me

#5 2016-08-08 20:46:19

danny_hal
Member
7 posts

danny_hal said:

Re: SQL Server Connection failure. java.sql.SQLException: Login timed out

Having the same issue. Any ideas?

Offline

#6 2016-08-11 10:52:47

xdshi
Talend Team


xdshi said:

Re: SQL Server Connection failure. java.sql.SQLException: Login timed out

Hi danny_hal,
We have replied to your another topic:https://www.talendforge.org/forum/viewtopic.php?id=3995
Could you please take a look at it?
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