Symptom
You want to set a new password for user “sa”. The “sa” (Sybase System Administrator) user is created during the Sybase software installation. The initial password set for user “sa” is NULL.
Solution
Login to the Sybase server using the “sa” user and execute following command,
%SYBASE%\%SYBASE_OCS%\bin\isql -Usa -P -Sserver-name
1> sp_password null, new_password
2> go
where “null” is the default password and new_password is the password that you are assigning to the “sa” account.
Note
It’s recommended that you set the password to have at least six characters, with a combination of letters and numbers.
