SAP Knowledge Base Article - Preview

3750939 - Error: "Connect timed out" while establishing connection to MSSQL database - SAP HANA Smart Data Integration

Symptom

  • Create connection/remote source to MSSQL database
  • Connection validation in SAP Datasphere failed with error
    "Failed to establish JDBC connection. Error: The TCP/IP connection to the host ***, port 1433 has failed. Error: "Connect timed out: /***:1433. 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.".
    (adapter type: MssqlLogReaderAdapter, source name: ***), Code: 5921, SQL State: HY000 


Read more...

Environment

  • SAP HANA Smart Data Integration
  • SAP Datasphere

Product

SAP HANA smart data integration 2.0

Keywords

MssqlLogReaderAdapter, DPAdapterAccess::Connect, 5921, HY000, tcp/ip connection timed out, jdbc timeout, dp agent, dpagentconfig.ini, proxyHost, proxyPort, squid proxy, outbound 1433, ms sql 2017, remote source, connection failed , 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.