SAP CPI JDBC Connection to Azure Synapse DB failure - "The driver received an unexpected pre-login"

[brandonleenaido]

Good day,

I am looking for some assistance regarding JDBC connection to Azure Synapse DB from SAP CPI.

I have setup JDBC connection as follows via Cloud Connector.

Cloud Connector:

JDBC on SAP CPI:

SAP CPI:

When I run my integration flow I get the following error:

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 1111 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:8344ef29-faec-4131-b3b0-0919c1c3246e, cause: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1111 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:8344ef29-faec-4131-b3b0-0919c1c3246e

Has anyone experienced this before and if so how do I resolve?

[nils_bente]

Deleted

[Ryan-Crosby]

As stated in the message the driver you are using is only for MS SQL... being a MS product does not mean it's synonymous with what this driver supports.

[nils_bente]

Deleted

[brandonleenaido]

Any advise on a solution?