Setting the System Administrator Password

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 Sybase system administrator should log in to the Cluster Edition 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
– is the password that you are assigning to the “sa” account.

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

If you change the password for the system administrator, or choose to use a different account than the system administrator to administer Adaptive Server, modify the Unified Agent configuration with the new password or account information. You can change the Unified Agent administrator account using the sybcluster 'set cluster login' command. See “The sybcluster Utility” chapter in the Clusters Users Guide for syntax and usage information.