Usage considerations for sqlsrvr.
The sqlsrvr utility is referred to as dataserver in other Sybase documents.
Start Adaptive Server using the services manager utility rather than by executing the sqlsrvr program directly. If you need to change any of the default parameters, edit the Adaptive Server Registry keys. See the configuration guide for your platform for details.
Adaptive Server derives its running environment from values in the sysconfigures system table. Run sp_configure to see the configuration values; use sp_configure and reconfigure to change the configuration.
Because Adaptive Server passwords are encrypted, you cannot recover forgotten passwords. If all system security officers lose their passwords, the -p parameter generates a new password for a system security officer’s account. Start Adaptive Server with -p, immediately log in to Adaptive Server with the new random password, and execute sp_password to reset your password to a more secure one.
By default, Adaptive Server logs error messages in both the local error log file and the local Windows event log. You can disable Windows event logging by including the -g parameter and specifying a different event-logging machine with -G machine_name. Use standard Windows conventions when entering the machine_name. For example, to designate a PC named “LOGSITE”, substitute “\\LOGSITE” for the machine_name. See the configuration guide for your platform for details on logging error messages.
After you have finished running the installer, set the file permissions on the sqlsrvr executable to limit who can execute it.
If you do not specify an Adaptive Server name with the -s parameter, and you have not set the DSLISTEN environment variable, sqlsrvr uses the default Adaptive Server name SYBASE. The value of the DSLISTEN environment variable overrides this default value, and the -s parameter overrides both the default and the DSLISTEN environment variable.
Automatic login lockouts can cause a site to end up in a situation in which all accounts capable of unlocking logins (system administrators and system security officers) are locked. If this occurs, use the sqlsrvr utility with the -u parameter to check the specified login for system administrator or system security officer authorization, unlock the account, and reset the value of the current failed logins counter to zero.
-f is only valid when used with -b and/or -w. The server fails to boot if you use -f without either -b or -w. -f forces the server in different ways, depending whether -w is present. See -b and -w below.