cancel
Showing results for 
Search instead for 
Did you mean: 

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

brandonleenaido
Explorer
0 Kudos
412

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:

brandonleenaido_0-1728637776901.png

JDBC on SAP CPI:

brandonleenaido_1-1728637946441.png

SAP CPI:

brandonleenaido_2-1728637971284.png

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
Explorer
0 Kudos

Deleted

Ryan-Crosby
Active Contributor
0 Kudos
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
Explorer
0 Kudos

Deleted

brandonleenaido
Explorer
0 Kudos
Any advise on a solution?

Accepted Solutions (0)

Answers (0)