cancel
Showing results for 
Search instead for 
Did you mean: 

* -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111

Former Member
0 Kudos
37,693

I just installed the SAP HANA virtual machine on VMWare. However, when I try to connect using hdbsql I'm getting this error:

hxeadm@hxehost:/usr/sap/HXE/HDB90> hdbsql

Welcome to the SAP HANA Database interactive terminal.

Type: \h for help with commands
\q to quit

hdbsql=> \c
Username: SYSTEM
Password:
* -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (localhost:30015))

Here are some doubts I have

1. What should the password be in this case? Should this be the default database password I set when I first started up the VM?

2. Do I need to enable some ports on the firewall? If so how should I do it?

View Entire Topic
dvankempen
Product and Topic Expert
Product and Topic Expert

Hi Kevin,

You are not telling hdbsql where to connect to, so it defaults to <localhost> with the first instance number possible: 00. This results in SQL port 30015. However, SAP HANA, express edition uses instance number 90, so the port that HANA listens to for SQL connection is 39015.

The SAP HANA interactive terminal, hdbsql, reports that the connection was refused but a clearer message would have been: there is no HANA SQL interface listening to port 30015.

See my blog post

So the connect strings above will only work if you execute them on the SAP HANA server with instance number 00. For the other 99.99% of the cases, you will need to provide the “node” information with -n or \n (or just the instance number when on “localhost”). In case of multitenant databases, add -d or \d with database name. hdbadm> hdbsql -u DBA -p P@$w0rd! -n <host>[:<port>] -i <instance number> or hdbsql> \c -u DBA -p P@$w0rd! \n <host>[:<port>] \i <instance number>

Does this answer your question?

Regards,

Denys / SAP HANA Academy

Subscribe to our YouTube Channel
Join us on LinkedIn
Follow us on Twitter
Github code samples
Facebook

former_member588946
Discoverer

Thanks Denys . It worked !!