sp_serveroption

Displays or changes remote server options.

Syntax

sp_serveroption [server, optname, optvalue]

Parameters

Examples

Usage

There are additional considerations when using sp_serveroption:
  • To display a list of server options that can be set by the user, use sp_serveroption with no parameters.

  • Once timeouts is set to false, the site handlers continue to run until one of the two servers is shut down.

  • The net password encryption option allows clients to specify whether to send passwords in plain text or encrypted form over the network when initiating a remote procedure call. If net password encryption is true, the initial login packet is sent without passwords, and the client indicates to the remote server that encryption is desired. The remote server sends back an encryption key, which the client uses to encrypt its passwords. The client then encrypts its passwords, and the remote server uses the key to authenticate them when they arrive.

  • To set network password encryption for a particular isql session, you can use a command line option for isql.

  • The security mechanism, mutual authentication, use message confidentiality, and use message integrity options apply to Kerberos logins only.

See also:
  • See the System Administration Guide for more information on server options.

  • isql in the Utility Guide

Permissions

The permission checks for sp_serveroption differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage server privilege. For a shared-disk cluster, you must be a user with manage server and manage cluster privileges.

Any user can execute sp_serveroption with no parameters to display a list of options.

Disabled

With granular permissions disabled, you must be a user with sa_role to set the timeouts option.

You must be a user with sso_role to set:

  • net password encryption

  • security mechanism

  • mutual authentication

  • use message confidentiality

  • use message integrity

Any user can execute sp_serveroption with no parameters to display a list of options.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

InformationValues
Event

38

Audit option

exec_procedure

Command or access audited

Execution of a procedure

Information in extrainfo
  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

Related reference
sp_helpserver
sp_password