SAP Knowledge Base Article - Preview

3041877 - SDI MSQL Test connecting returns: Test unsuccessful for remote source, Failed to establish JDBC connection. Error: The TCP/IP connection to the host ;<Host> has failed

Symptom

  • SAP HANA Web-based Development Workbench Connection test  fails with:
    403 - SQL error, server error code: 403. internal error: Test unsuccessful for remote source <Remote Source> Reason: Adapter validation failed. [<Remote Source>] Failed to establish JDBC connection. Error: The TCP/IP connection to the <Host and Port> has failed. Error: "connect timed out (local port 58567 to address 0:0:0:0:0:0:0:0, remote port 1433 to address xx.xxx.xxx.xxx (xxxxxx.xxx.xxx.xxx)). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a f at BuiltinProcedure/impl/BP_CheckRemoteSource.cpp:81
  • framework.trc shows:
    2021-03-29 17:37:05,841 [ERROR] DPFramework | WorkerThread.processRequest  - com.sap.hana.dp.adapter.sdk.AdapterException: Adapter validation failed. [<Remote Source>]Failed to establish JDBC connection. Error: The TCP/IP connection to the <Host and Port> has failed. Error: "connect timed out (local port 58462 to address 0:0:0:0:0:0:0:0, remote port 1433 to address xx.xxx.xxx.xxx (xxxxxx.xxx.xxx.xxx)). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". Context: com.sap.hana.dp.adapter.sdk.AdapterException: Adapter validation failed. [<Remote Source>]Failed to establish JDBC connection. Error: The TCP/IP connection to the <Host and Port> has failed. Error: "connect timed out (local port 58462 to address 0:0:0:0:0:0:0:0, remote port 1433 to address xx.xxx.xxx.xxx (xxxxxx.xxx.xxx.xxx)). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
                                    at com.sap.hana.dp.mssqllogreaderadapter.MssqlLogReaderAdapter.sdaOpen(MssqlLogReaderAdapter.java:573)
                                    at com.sap.hana.dp.cdcadaptercommons.StatefulAdapterCDC$NotOpened.open(StatefulAdapterCDC.java:802)


Read more...

Environment

  • DPAagent version=2.5.1.0 
  • MssqlLogReaderAdapter

Product

SAP HANA smart data integration 2.0

Keywords

JDBC connection TCP/IP CheckRemoteSource , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.