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