How to reset 'sa' password if SQL Password is lost/forgotten/unknown?
First off, you can log in as any SSO role user and have them
reset the 'sa' password for you.
Being life and life being not always so simple we may not always have an SSO role handy (or configured)
So, we resort to the following:
- Edit the ‘runserver' file. By default it's in the $SYBASE_HOME/install directory
- Add "-psa" (for password 'sa') to the end of the command line. (I have noticed that this DOES NOT work in windows unless it's the FIRST param on the command line)
- Save file and reboot server. You ‘may' have to use Unix ‘kill' or Windows ‘End Task' but I suggest that as a last resort.
...
