[resolved] remote MS SQL 2008 R2 connection timeout
Hello,
I'm struggling with connection to MS SQL server 2008 R2 on a remote server...
Indeed, I'm always getting a timeout error ( java.lang.RuntimeException: java.sql.SQLException: Login timed out.).
TCP/IP is enabled on the server.
I use a SQL server login.
I can connect to this remote SQL server with SQL Server Management Studio.
I can connect to a local SQL Server express 2012 on my laptop with TOS without any issue.
I use TOS 6.1.0
Any idea of what's going wrong?
Many thanks in advance 🙂 Sylvain
Hello,
We seem to get the same problem in talend 6.1.1 :
Echec de la connexion Vous devez modifier les paramètres de la base de données.
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: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: 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.SocksSocketImpl.readSocksReply(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
My jobs work but we can't check the connection or retrieve table schemas from metadata (we also get the problem with AS400 connections).
do you have any issues about it ?
Thanks for your help,
Regards,
Rudy
Hi Rudy, Are you able to connect to the SQL Server database successfully via client without using Talend Tool? Is there any connectivity or firewall issue for you? Best regards Sabrina
I 've just found how to solve my problem : I delete the proxy settings for SOCKS entry in preferences>>General>> Network Connections hope this help Rudy