21
Warning: dataserver -p option fails. Please check for state '%d' to see where it fails.
This error occurs when Adaptive Server is unable to create a new password for a user with “sso” role in response to the dataserver command with the -p option.
This error is raised with three possible states:
State |
Meaning |
|---|---|
1 |
Login passed with the -p option does not exist in syslogins. |
2 |
Login exists but does not have the “sso” (system security officer) role. |
3 |
Call to the routine that sets the passwords failed. This routine generates its own errors to help diagnose the problem. |
The actions for recovering from error 1623 are listed below, by state.
If you did not remove the “sso” role from the “sa” login, use “sa” in the dataserver command in your runserver file. If you did remove the “sso” role from the “sa” login, choose the option that is appropriate from the following choices.
If you can, log in to Adaptive Server as any user.
Determine which login names have “sso” role:
1> use master 2> go
1> select l.name, s.name from sysloginroles slr, 2> syslogins l,syssrvroles s 3> where slr.srid = 1 and slr.suid = l.suid and 4> slr.srid = s.srid 5> go
If you cannot log into Adaptive Server as any user, and you have a historical dump of the master database that includes a user with the “sso” role and for which you know the password, create a new master device, load that dump and determine whether you can log into it.
Refer to “master database is corrupt and Adaptive Server starts,” “Valid dump of the master database exists” in the chapter “Adaptive Server System Recovery” in the most recent version of Troubleshooting and Disaster Recovery for instructions on how to re-create your master database.
If you cannot log into Adaptive Server as any user and do not have a historical dump of the master database, refer to “master database is corrupt and Adaptive Server does not start,” “Valid dump of the master database does not exists” in the chapter “Adaptive Server System Recovery” in the most recent version of the Troubleshooting and Disaster Recovery for instructions on how to re-create your master database.
Other error messages will be listed. Follow the directions in this manual for recovering from those errors. If no directions exist, call Sybase Technical Support.
All versions
