Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database server options

 

-ep server option

Prompts the user for the encryption key upon starting a strongly encrypted database.

Syntax
{ dbsrv11 | dbeng11 } -ep ...
Applies to

All operating systems and database servers.

Remarks

The -ep option instructs the database server to make a window appear for the user to enter the encryption key for database started on the command line that require an encryption key. This server option provides an extra measure of security by never allowing the encryption key to be seen in clear text.

When used with the server, the user is prompted for the encryption key when the following are all true:

  • the -ep option is specified

  • the server is a Windows personal server, or the server is just starting up

  • a key is required to start a database

  • the server is either not a Windows service, or it is a Windows service with the interact with desktop option turned ON

  • the server isn't a daemon (Unix)

If you want to secure communication packets between client applications and the database server use the -ec server option and transport-layer security. See Transport-layer security.

See also
Example

The user is prompted for the encryption key when the myencrypted.db database is started:

dbsrv11 -ep -x tcpip myencrypted.db