A user account called “sa” is created for the Sybase System Administrator when you install the Sybase software. A user logged in as “sa” can use any database on Adaptive Server, including master, with full privileges.
Immediately after a new installation, there is no password on the “sa” account. The initial default value for the password is NULL. In a production environment, the Sybase System Administrator should always use a non-default password.
The System Administrator should log in to the new Adaptive Server as “sa” and set a password using sp_password:
%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.
If Job Scheduler was configured to use the sa account an additional step is necessary whenever the sa password is changed. Once the sa password has been changed the following command will need to be executed:
1> sp_addexternlogin loopback, sa, sa, new_password 2> go
For greatest security, Sybase recommends that you set the password to have at least six characters, with a combination of letters and numbers.
