10709: Connection failed (RTE:[89013] connecting HDBSQL to SAP HANA Cloud

[julian_runner]

On my Windows machine, I use following command to connnect to SAP DWC

hdbsql -u <USER> -p <PASSWORD> -n <HOST IP>:443 -e

I get this error

* -10709: Connection failed (RTE:[89013] Socket closed by peer {#### -> ####} (####:443))

My IP address is listed in the allowlist in SAP DWC

PS.: As I'm on Windows, I do not explicitly provide the trusted root certificate to the client.

[Vitaliy-R]

Hi Julian. I have seen this error `89013` only once: when the server disconnects a connection with something like this SQL statement:

ALTER SYSTEM DISCONNECT SESSION 'your-session-id'<br>

Could you check that your `hdbsql` is on the latest 2.11 version, which got improvements in handling disconnected sessions (see https://help.sap.com/viewer/79ae9d3916b84356a89744c65793b924/2.11/en-US/22485d2937c4427fbbedefe3cc15...

Regards.

[julian_runner]

Hi Witalij,

thanks for your reply.

I'm using HDBSQL version 2.11.14.1636568807.

Could it be a whitelisting problem? I only have problems when using a VPN connection (although I whitelisted the IPs). Using my private IP I can establish a connection to the host without any problem.

Best Regards,

Julian

[Vitaliy-R]

Hi julian_runner. Indeed, I just tried with my instance of HANA Cloud db, and when my VPN address is not in the list of allowed addresses I got the same `-10709: Connection failed (RTE:[89013] Socket closed by peer...` message as you did.