How to reset sa password on SAP ASE Sybase ?

While upgrading or patching SAP ASE Sybase database, we need credentials for user sa in the SAP secure store. Otherwise, you will get below error:

Error: sapdbctrl: Failed to logon sa. Please provide valid sa credentials in the SAP Secure Store.
Error: saphostcontrol: LiveDatabaseUpdate failed <sapdbctrl exit code = 1>

Solution is to reset the sa password.

To reset the sa credentials follow below steps:

1. Logon to isql session with sapsso login to change sa password :

isql -S <SID> -U sapsso -P <sapsso_password> -X
use master
go
alter login sa with password “<sapsso_password>” modify password “<new_sa_password>”
go

isql is stored under %Sybase%\<SID>\OCS-<version>\bin

2. Login as <SID>adm and use rsecssfx command to update ‘sa’ password in SAP Secure Store:

rsecssfx put DB_CONNECT/SYB/SAUPDDB_USER sa -plain
rsecssfx put DB_CONNECT/SYB/SAUPDDB_PASSWORD <passwd>