Cannot reset SYSTEM user

[Former Member]

Hello,

I am facing an issue, I am not able to connect to HANA with SYSTEM account. I tried via the studio and via command line but it's not working.

Then I stopped HANA and I tried to reset the SYSTEM password with the hdbnameserver -resetUserSystem command line, but I am having this error.

If anyone faced this issue?

Thank you for your help

[deepak_chodha]

Hi Majid,

Saw you getting troubled a lot here. Sorry about that. For your information the way of resetting the password of SYSTEM user has changed.

1. is your system a Multi-tenant db or Single db?

2. Depending upon that you got to execute different commands. All steps using <sidadm>

If it is multidb and you want to reset SYSTEM user password for system/tenant db follow: Guide for Multidb

If it is a single db and you want to reset the SYSTEM user password follow: Guide for Single

3. And about the issue you are getting for library I guess that will be resolved by running hdbenv.sh using sidadm user.

Try it and let us know the result.

Happy HANA, Deepak.