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

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.