SAP Knowledge Base Article - Preview

3327084 - "com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port <port nr.>has failed." - error while connecting MSSQL database using cloud connector via JDBC driver in Cloud Integration

Symptom

During message processing you get similar error log for your message in the Integration flow:

"org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port <port nr.> has failed. Error: "The driver received an unexpected pre-login response. Verify the connection properties and check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. This driver can be used only with SQL Server 2005 or later.". ClientConnectionId:<>"


has failed." - error while connecting MSSQL database using cloud connector via JDBC driver in Cloud Integration"> Read more...

Environment

  • SAP Integration Suite
  • SAP Business Technology Platform
  • Cloud Integration

Product

Cloud Integration all versions

Keywords

Cloud Integration, SAP Integration Suite, SAP Cloud Platform Integration, Cloud Platform Integration, SAP CPI, CPI, SCPI, HANA Cloud Integration, HCI, SAP HCI, tenant, iFlow, Integration Flow, org.springframework.jdbc.CannotGetJdbcConnectionException, com.microsoft.sqlserver.jdbc.SQLServerException
, KBA , LOD-HCI-PI-CON-RFC , RFC Adapter , 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.