Connection timed out SQL Server

MBOUNAJRA — Fri, 15 Nov 2024 22:56:29 GMT

I use tDBConnection component to connect on SQL Server db and I receive this error. Any help would be greatly appreciated

Exception in component tDBConnection_2

java.sql.SQLException: Network error IOException: Connection timed out: connect

at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)

at java.sql.DriverManager.getConnection(Unknown Source)

...

Caused by: java.net.ConnectException: Connection timed out: connect

at java.net.DualStackPlainSocketImpl.connect0(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)

... 9 more

Re: Connection timed out SQL Server

gjeremy1617088143 — Mon, 09 May 2022 15:30:27 GMT

Hi @MOURAD BOUNAJRA ,

have you checked you have the good rights on the database?

You can also ping the server where the database is,

maybe you fulfill the wrong informations in the fields of the tDB component.

Could you send screenshots of your job and components without sensible informations ?

MBOUNAJRA — Wed, 11 May 2022 15:51:05 GMT

Hi @guenneguez jeremy The ping doesnt work