How do I reset ‘sa’ password in SYBASE
When SYBASE get started, the following call is made:
startserver -f RUN_MYINSTANCE
RUN_MYINSTANCE is located in $SYBASE_HOME/install.
1/ edit RUN_MYINSTANCE and add the following line, where the switches are:
-psa
2/ run startserver -f RUN_MYINSTANCE
During the boot phase you will see something like, e.g:
New SSO password for sa:uvwxyz
You can also see this message in Sybase logs.
3/ edit RUN_MYINSTANCE and remove the line you added in step 1/, so you do not reset it next time.
4/Set your own password:
isql -Usa -SMYINSTANCE (using ‘uvwxyz’ password)
>sp_password “uvwxyz”,”my_own_password”
>go
