Server option "net password encryption"

Adaptive Server also acts as a client when establishing a remote procedure call (RPC).

When connecting to remote servers, Adaptive Server uses on the “net password encryption” server option to determine whether it will use password encryption.

Adaptive Server uses either RSA or Sybase proprietary algorithms when this server option is set to “true.” The command to enable “net password encryption” is:

sp_serveroption server, "net password encryption",
    "true"

The setting is stored in master..sysservers and the value of server options are displayed using sp_helpserver stored procedure.

In this release, the default value for net password encryption is “true” for any new server added using sp_addserver. During upgrade, Adaptive Server sets net password encryption to “true” for sysservers entries with an ASEnterprise class value. No other server classes are modified. This is done to improve password security between two communicating Adaptive Servers.

NoteThe administrator may reset net password encryption to false if you encounter problems establishing a connection to a server. However, if the option is set to false, your password is transmitted in clear text on the network.