Symptom
ü Lost password for SA account.
ü How to recover the lost password for SA account?
ü How to re-create a new password for SA account?
Resolution
ASE can generate a random password for the SA account, and display -> encrypt -> save it in 'master..syslogins' by using the parameter '-plogin_name' of the utility dataserver.
Follow the below steps to generate a new password:
1.Login to the operating system with Sybase user
Shutdown the server (it may be necessary to kill ASE from the OS level).
example : syd<sid> or sybase.
NOTE : Here my sybase id is root
2. Go to the below
directory
|
cd Sybase/<SID>/ASE-16_0/install
|
Open the RUN_SID file
and add '-psa' (without the quotes) as a new
parameter to dataserver,Make sure this change has been saved before exiting the
editor
4. Start your Sybase server and while executing, you will get a new password printed on the terminal screen like below.
5. Remove the -psa entry from the RUN_SID file, save changes.
ASE does not reset the password again the next time ASE is rebooted.
NOTE: This process can be used for any login
that has the sa_role
6.Login isql with password displayed on terminal screen and change the password as per the requirement .
NOTE : incase any user having sso_role they can unlock sa/sapsso password .