3586103 - Error "No 101 Switching Protocols status found" when validate S/4HANA On-Premise connection in Datasphere

Cloud Connector is selected for Data Provisioning Option under Remote Tables section of S/4HANA On-Premise connection to use the ABAP SQL service to federate data with remote tables.

When validate the S/4HANA On-Premise connection in Datasphere, below error message is displayed in the details:

Remote Tables: Unable to connect remote source: [SAP][ODBCforABAP] (08001) Open backend connection: Error during handshake response: No 101 Switching Protocols status found, Code: 5921, SQL State: HY000

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."   

SAP Datasphere

1. Select the checkbox in front of the connection to S/4HANA On-Premise.
2. Click Validate button.

WebSocket is not activated in the Cloud Connector. The "ODBC Driver for ABAP" definitely needs this protocol, HTTPS is not sufficient.

1. Select the entry in Cloud Connector.
2. Click edit icon to show Edit Resource dialog.
3. Select the WebSocket checkbox and save.
   
   In version 2.18.0 and above of Cloud Connector, select the Upgrade Allowed checkbox and save.
   

• Using ABAP SQL Services for Accessing Data from SAP S/4HANA
• Configure Cloud Connector

KBA , DS-DI-CON , Connections , Problem