Following an interesting conversation at the SAP User Group Conference about a lost password for SAP MaxDB I embarked on what I expected to be a quick bit of investigation. I searched the SAP Support Portal along with the SDN and was amazed I couldn’t find a reset procedure.
MaxDB Password Reset Procedure – Video Walkthrough
Ideally take a backup first and if you’re able to bring the database down before editing then all the better, failing that a reboot immediately after seems to keep things happy. I have seen an error once or twice when then first changing the password but re-trying the command has always cleared things up.
MaxDB 7.6 Password Reset
MaxDB 7.7 Password Reset
Find the target user in the upc file, paste in a password hash which sets to ‘password’. Save and reboot.
Sample Hashes :
password = 358883B07AA93121891B4A932433115FB3DC1CC00B5027D8
sap = D8835545B45CD7401D82B49D2433115FB3DC1CC00B5027D8
MaxDB 7.8 Password Reset
Find the target user in the upc file, paste in a both password hashes as shown which sets to ‘password’. Save and reboot.
password = 358883B07AA93121891B4A932433115FB3DC1CC00B5027D8 041819B201CD7CA6281FC4507B5F3866145D8A61D7246E1FD928
Setting the dbm users password to ‘newpassword’ with both the older version of dbmcli found in the database manager tool and then with current version, this keep everything in a happy consistent state.
For a small bit of background check out How I Discovered the MaxDB Password Reset Procedure