Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:?]
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
@Aiming Chen
How to check Firewall of Sql Server ?
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!
Hello @rohit bannagare ,
Please check with your IT about the firewall issue, thanks
Hello,
Moved this topic to Design and Development board.
Best regards
Sabrina