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.
SAP Knowledge Base Article - Preview