Setting the System Administrator Password

When you install Sybase software, the software creates a system administrator account called "sa," which can use any database on Adaptive Server, including master, with full privileges.

Immediately after a new installation, the default password is set to NULL, and Adaptive Server asks you to set a password for "sa." For security purposes, assign a password to "sa" before using Adaptive Server in a production environment, you cannot use a NULL password for "sa."
Log in to Adaptive Server as "sa" and set a password:
$SYBASE/$SYBASE_OCS/bin/isql -Usa -P -Sserver_name
1> sp_password default, new_password
2> go
where:
  • default – is the non-null password.
  • new_password – is the password that you are assigning to the "sa" account.

For the greatest security, SAP recommends that you create a password of at least six characters, with a combination of letters and numbers.