Skip to Content
0
Nov 20, 2021 at 05:58 PM

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

1148 Views

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