Displays or changes remote server options.
sp_serveroption [server, optname, optvalue]
is the name of the remote server for which to set the option.
is the name of the option to be set or unset. Table 1-20 lists the option names.
Adaptive Server accepts any unique string that is part of the option name. Use quotes around the option name if it includes embedded blanks.
is true (on) or false (off) for all options except the security mechanism option.
For the security mechanism option, specify the name of the security mechanism. To see the names of the security mechanisms available on a server, execute:
select * from syssecmechs
Displays a list of the server options:
sp_serveroption
Settable server options. ------------------------ cis hafailover external engine auto start mutual authentication negotiated logins net password encryption readonly rpc security model A rpc security model B security mechanism server cost server logins timeouts use message confidentiality use message integrity
Tells the server not to time out inactive physical connections with the remote server GATEWAY:
sp_serveroption GATEWAY, "timeouts", false
Specifies that when connecting to the remote server GATEWAY, GATEWAY sends back an encryption key to encrypt the password to send to it:
sp_serveroption GATEWAY, "net password encryption", true
Specifies that the EJB Server SYB_EJB starts up each time Adaptive Server starts up:
sp_serveroption SYB_EJB, "external engine auto start", true
Specifies that the security model for RPCs for the server “TEST3” is security model B.
sp_serveroption TEST3, "rpc security model B", true
Specifies that the security model to use for RPCs for “TEST3” is DCE:
sp_serveroption TEST3, "security mechanism", dce
Specifies that the local server will check the authenticity of the remote server “TEST3”. With security model B, the remote server will check the authenticity of the local server, whether or not this option is set:
sp_serveroption TEST3, "mutual authentication", true
Disables automatic startup, where SYB_EJB is the logical name of the EJB Server:
sp_serveroption 'SYB_EJB', 'external engine auto start', 'false'
To enable automatic startup, enter:
sp_serveroption 'SYB_EJB', 'external engine auto start', 'true'
See “Starting EJB Server automatically” in Chapter 2, “Getting Started” of the EJB Server User’s Guide for more information about using external engine auto start.
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 will 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. For more information, see the Utility Programs manual for your platform.
You cannot use the net password encryption option when connecting to a pre-release 10.0 SQL Server.
The options security mechanism, mutual authentication, use message confidentiality, and use message integrity do not apply to security model A.
To use security model B, both the local server and the remote server must use model B and both must use the same security mechanism.
Only a System Administrator can execute sp_serveroption to set the timeouts option. Any user can execute sp_serveroption with no parameters to display a list of options.
Only a System Security Officer can set the net password encryption, security mechanism, mutual authentication, use message confidentiality, and use message integrity options.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
Documents See the System Administration Guide for more information on server options.
System procedures sp_helpserver, sp_password
Copyright © 2005. Sybase Inc. All rights reserved. |