Prompts the user for the encryption key upon starting a strongly encrypted database.
iqsrv16 -ep ...
All operating systems and database servers.
The -ep option instructs the database server to display a window where the user enters the encryption key for databases 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 database server, the user is prompted for the encryption key when the following are all true:
the -ep option is specified
the server is just starting up
a key is required to start a database
the database 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)
To secure communication packets between client applications and the database server, use the -ec server option and transport-layer security.
The user is prompted for the encryption key when the myencrypted.db database is started:
iqsrv16 -ep -x tcpip myencrypted.db