Connection timed out SQL Server

[MBOUNAJRA]

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)

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

[gjeremy1617088143]

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]

Hi @guenneguez jeremy​  The ping doesnt work