cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

HANA Express Edition-SAP Control Request failed

Prince_121083
Explorer
0 Kudos
487

I have installed Hana Server edition in my laptop  but when I am trying to add this in eclipse its giving error sap control request failed .

Accepted Solutions (0)

Answers (1)

Answers (1)

Dan_vL
Product and Topic Expert
Product and Topic Expert

On your laptop, check that you can successfully ping to the machine running SAP HANA express.  For example, ping hxehost. 

If it is a Windows machine, you can update your hosts file.
127.0.0.1 localhost hxehost

The following might be used to verify that the database is started and reachable.
Switch to the hxeadm user
sudo su hxeadm

Attempt to connect to the server using hdbsql which should be located at /usr/sap/HXE/HDB90/exe/hdbsql

hdbsql -n hxehost:39013 -u SYSTEM -p YourHanaPWD1234


If that is successful, you can query to see the details of the port used by the SQL Port used by the tenant database using:
SELECT * FROM SYS_DATABASES.M_SERVICES WHERE SQL_PORT != 0;

Prince_121083
Explorer
0 Kudos

Screenshot 2024-08-24 003224.jpgScreenshot 2024-08-24 003304.jpgI have update the file and executed the above command its working but i am not able to connect . same error

Dan_vL
Product and Topic Expert
Product and Topic Expert
0 Kudos
It looks like the HANA server is started and is running on port 39013 and 39015. In Eclipse, in the properties for the connection, there is a section calle Hosts Used to Connect. Have you tried adding hxehost there?