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