Network error IOException: Connection timed out (Connection timed out) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

[rohit1804]

Hi

I am trying to connect Microsoft SQL Server via Linux Server I am getting below error:

Where as when I am connecting to same Microsoft SQL server via local studio its working as expected, also when I trying connect to it via different Linux server it working

Can you please help me

Below is the error:

tDBConnection_2 Network error IOException: Connection timed out (Connection timed out)

java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

@at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436) ~[jtds-1.3.1-patch-20190523.jar:?]

@at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184) ~[jtds-1.3.1-patch-20190523.jar:?]

@at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]

@at java.sql.DriverManager.getConnection(DriverManager.java:228) ~[java.sql:?]

@at coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tDBConnection_2Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:1566) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@at coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tJava_1Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:1387) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@at coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tOracleConnection_1Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:1164) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@at coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tJava_7Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:4367) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@at coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tJava_5Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:4140) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@at coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.runJobInTOS(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:5344) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@at coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.main(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:4715) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

Caused by: java.net.ConnectException: Connection timed out (Connection timed out)

@at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:?]

@at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412) ~[?:?]

@at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255) ~[?:?]

@at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237) ~[?:?]

@at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:?]

@at java.net.Socket.connect(Socket.java:608) ~[?:?]

@at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288) ~[jtds-1.3.1-patch-20190523.jar:?]

@at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251) ~[jtds-1.3.1-patch-20190523.jar:?]

@at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331) ~[jtds-1.3.1-patch-20190523.jar:?]

[Anonymous]

Hello @rohit bannagare​ ,

Regarding to the error log, the problem is that the linux server can't connect to the sqlserver due to network issue.

Could you please try to check the firewall of sqlserver ​to allow the access of the linux server?

Best regards

Aiming

[rohit1804]

@Aiming Chen​ 

How to check Firewall of Sql Server ?

[jlolling_kloeckner]

It is really so hard to understand that we have here different forums for different purposes?

This current forum is for ANNOUNCMENTS and NOT for technical questions!

Please do not spread your questions without thinking!

[Anonymous]

Hello @rohit bannagare​ ,

Please check with your IT about the firewall issue, thanks

[Anonymous]

Hello,

Moved this topic to Design and Development board.

Best regards

Sabrina