Logging in after losing a password

Use the dataserver -plogin_name parameter to specify the name of the system security officer or system administrator at the server start-up. This allows you to set a new password for these account if there is no way to recover a lost password.

When you start with the -p parameter, Adaptive Server generates, displays, and encrypts a random password and saves it in master..syslogins as that account’s new password.

You can use dataserver -p to reset the password for sa_role and sso_role. Use dataserver -p when you have lost the password for either of these roles, that require a password to become active.

For example, if the server is started with:

dataserver -psa_role

Adaptive Server displays this message:

New password for role 'sa_role' : qjcdyrbfkxgyc0

If sa_role does not have a password, and it is started with -psa_role, Adaptive Server prints an error message in the error log.

Sybase strongly recommends that you change the password for the login or role when the server restarts.