How to Change SAPABAP1 HANA Schema Password

This article will show you the steps to take when changing the SAPABAP1 HANA database schema password.

Step 1: Bring down the SAP application server(s).

Step 2: Launch the SAP HANA Studio and change the password of SAPABAP1.

Step 3: Login to the application server as sidadm. Execute below command to update the hdbuserstore. In our case, the application server is on Windows operating system.

hdbuserstore -u [SAPServiceSID] set default [DB_HOSTNAME]:[DB_PORT] [DB_USER] [DB_PASSWORD]

Note: If you are getting Error 91007: Impersonation not supported, use sudo on this platform. Use below command instead,

hdbuserstore set default [DB_HOST]:[DB_PORT] [DB_USER] [DB_PASSWORD]

Step 4: Once executed, confirm the database connection test by using the R3trans -d. In some cases of the error return code, please check on the user’s password or user deactivation status (too many invalid connect attempts).

Step 5: Bring up the application server.