JDBC connectivity in SAP CPI to on-premise SQL server with SCC

[former_member703923]

Hi Experts,

I'm trying to access on-premise SQL Data-Base system via JDBC adapter, but am getting below error :

The TCP/IP connection to the host localhost, port 1105 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.

I tried changing the protocol to TCP in cloud connector but still getting the same error.

URL format used : jdbc:sqlserver://<Virtual Host>:<Virtual Port>;DatabaseName=<Schema Name>;

Drivers also installed.

Kindly advice how to proceed further.

BR,

MANI REDDY

SAP CPI

[Sakshi_T]

Hi, I'm getting similar error in my IFLOW. Could you please help me with the solution?

[philippeaddor]

Hi Mani,

I guess you have found the solution to your problem in the meantime. I was just facing the same error, but for a cloud server, not on-prem. In my case, the DB server is running on a virtual machine in the cloud. However, I accidentally chose "SQL Server (On-premise)" in the JDBC Data Source Alias. After changing to "SQL Server  (Cloud)" the error disappeared.

Regards,

Philippe

[Sriprasadsbhat]

Hello Mani,

Please refer below blog to know supported JDBC versions and your error looks like you are trying to connect the db with older versions.Also you need to verify version compatibility of JDBC drivers & backend database.

https://help.sap.com/viewer/368c481cd6954bdfa5d0435479fd4eaf/Cloud/en-US/77c7d9550e12494eb600ec82496...

Regards,

Sriprsad Shivaram Bhat

[yogananda]

hi mani.kantha.reddy

All the below links will help to your questions.

https://blogs.sap.com/2020/12/18/cpi-connectivity-with-ms-sql-server-on-prem-using-cloud-connector/
https://blogs.sap.com/2020/01/08/cloud-integration-connect-cpi-with-your-on-premise-mail-server/
https://blogs.sap.com/2021/10/08/configuration-of-jdbc-adapter-to-poll-data-from-database-in-cloud-i...
https://blogs.sap.com/2018/11/26/how-to-connect-cpi-and-pi-system-to-import-mappings-via-sap-cloud-c...
https://blogs.sap.com/2021/06/11/step-by-step-procedure-to-establish-cloud-connector-to-cpi-connecti...
https://blogs.sap.com/2017/06/02/how-to-use-sap-cloud-connector-with-sap-cloud-platform-integration-...

[former_member703923]

Hi,

Thanks for the response but in the above blogs, the steps are mentioned but not the error which i'm getting.
Would be great if i get some relevant error information.