Requirement: You need to reset SYSTEM user password and do not have any other user with system privilege USER ADMIN role assigned.
Prerequisites : You need password of <SID>ADM user.
Steps :
- Login to your HANA host using <SID>adm user. If you do not have password of <SID>adm user then you can use root like user to reset <SID>adm password at OS level.
- Stop the HANA database by using command “HDB stop”.
- Now we will start Name server and Compiler server in batch mode.
- Execute command hdbnameserver & and press enter to get the shell prompt again.
- Execute command hdbcompileserver & and press enter to get the shell prompt again.
![](http://4.bp.blogspot.com/-7f62220v0pk/VSQkCjLjY7I/AAAAAAAAECc/BTNy6QpcLSQ/s1600/Start_NameServer_Compiler_in_Batch_mode.png)
- Now we will start index server in console mode so that we can issue the password reset SQL,execute command : hdbindexserver –console
- When you see Service started message then press enter and execute following SQL.
ALTER USER SYSTEM PASSWORD Ina123 //Ina123 is password in our case, you can choose your own.
![Reset SYSTEM user password SQL](http://2.bp.blogspot.com/-Mfx8eyW-QCc/VSQmLACnp1I/AAAAAAAAECo/6YxBPBxcJvo/s1600/Reset_HANA_SYSTEM_user_Password.png)
- Now your password is reset , press CTRL-C to stop the indexserver console mode and kill the hdbnameserver and hdbcomplie server process.
- To kill the name server and complie server , Check their OS level process by executing “ps -eaf| grep <sid>adm” and execute the kill command.
![Kill name server and compile server](http://3.bp.blogspot.com/-j-WRMTegb4g/VSQmzDQ2N-I/AAAAAAAAECw/8Sytw5vNuYE/s1600/Kill_name_compile_server.png)
- Now start HANA by executing “HDB start” and try to connect using HANA studio or hdbsql with new SYSTEM user password.