SAP CPI: JDBC On-premise database connectivity error

[naveenkk]

Hi Experts,

While connecting to the on-premise MYSQL server from the CPI we are facing the below error. 
Even though i have completed all the prerequisites:
1. Configured the cloud connector setup under the TCP protocol and the status is reachable.

2. Deployed the required sql drivers.
3. Configured the JDBC data source 

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 1112 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:130a9bdc-ccd1-4420-8277-51b57c4249a7, cause: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1112 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:130a9bdc-ccd1-4420-8277-51b57c4249a7"

Please help to resolve the issue.

Thanks,

Naveen

[Magi11]

Hi, Did you resolve this issue? If so, can you please let me know the resolution? Thanks.

[Ryan-Crosby]

MS SQL is not the same as MySQL, and there is not an available MySQL driver in CPI.

Regards,

Ryan Crosby

[kiran0009]

Hi Naveen,

I’m encountering the same error when trying to connect to the on-premise database from the IS. Could you please share the resolution steps if you’ve found any solutions?

Thanks in advance!

[ostosjuan99]

Hi Kiran, did you find the solution?