Usage for sqlsrvr

Usage considerations for sqlsrvr.

  • The sqlsrvr utility is referred to as dataserver in other Sybase documents.

  • Start the SAP ASE 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 SAP ASE Registry keys. See the configuration guide for your platform for details.

  • An SAP ASE 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 SAP ASE 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 the SAP ASE server with -p, immediately log in to the SAP ASE server with the new random password, and execute sp_password to reset your password to a more secure one.

  • By default, the SAP ASE 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 SAP ASE name with the -s parameter, and you have not set the DSLISTEN environment variable, sqlsrvr uses the default SAP ASE 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.

See also:
  • Reference Manual: Commandsdisk mirror, disk remirror, reconfigure
  • Reference Manual: Proceduressp_configure, sp_password