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
Find the target user in the upc file, overwrite the hash with zeros. Save and reboot.
Setting the control users password to ‘password’
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
Setting the dbm users password to ‘newpassword’
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.
Sample Hashes:
password = 358883B07AA93121891B4A932433115FB3DC1CC00B5027D8 041819B201CD7CA6281FC4507B5F3866145D8A61D7246E1FD928
sap=
D8835545B45CD7401D82B49D2433115FB3DC1CC00B5027D8 04188B272DD84C48BA488F55E5B9012916D651F522CEEF0D29DC
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
nice thanks!
what editor do you use to paste/replace the characters in the file?
hex workshop is my favourite tool to use – http://www.hexworkshop.com/