Blog Pages

SAP ASE (Sybase) - reset sa password

For ASE 15.7:
alter login sa with password 'OLDPASSWORD' modify password 'NEWPASSWORD'

For other ASE:

sp_password 'OLDPASSWORD','NEWPASSWORD' ,sa


If you forgot the password and can't login:

1. go to <SAPFOLDER>/ASE-XX_X/install/
2. Edit the RUN_SID file, add new line in the end of it with: (p=password, sa=sa)
-psa
3. reset server. if you don't have a login to do that - restart the server machine.
4. start SAP ASE: 
<SAPFOLDER>/ASE-XX_X/install$ ./startserver -f RUN_SERVERNAME
5. while executing the startserver, a new password will be printed on the terminal screen:
New SSO password for sa:ldxsqzfammlsw2
6. login as sa with the new password
7. change password

No comments:

Post a Comment