a month ago
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?
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.