Here is a procedure to reset the "sa" password for Sybase. But first, the RUN_ESOFTHUB_SVR script will have be modified. Here is a terse rundown of this procedure.
Run a tail -f to observe the new SSO password in the log.
# tail -f SYBASE.log
The dataserver should not be running
# ps -ef | grep dataserver
Append the following entry, -psa, to this file
# vi RUN_ESOFTHUB_SVR
...
-psa
:wq!
Starts the dataserver
# startserver -f RUN_ESOFTHUB_SVR
Observe the new password in the console or SYBASE.log
# vi RUN_ESOFTHUB_SVR
...
-psa (delete this line)
:wq!
# isql -Usa -Pfrom_the_log_file
Now use sp_password to change the "sa" password to something permanent.
No comments:
Post a Comment