Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

The wish is to start encrypted HA databases without hard-coding encryption keys in the service configurations... the administrato will enter the key when the database is started.

According to the Help dbsrv17 -ep "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" when "The database server isn't a Windows service".

So... how does one get that functionality for an HA partner database when dbsrv17 is started as a service?

Does one start the service without the database specified on the command line, and then use a custom client that runs START DATABASE ... KEY ... MIRROR ON?

asked 13 Jul '19, 08:21

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

Isn't running a service and supplying start parameters via hand somewhat contradictory?

As to the background, see that older FAQ

(13 Jul '19, 09:42) Volker Barth

If you are starting the server as a service, Windows does not allow the process (i.e. the server in this case) to interact with the desktop user. As a result the -ep switch cannot be used to have the server to prompt the desktop user for the encryption password.

You will need to use some other method to start the service (e.g. start the service as a Windows Startup process) OR use some other method to provide the database encryption key (e.g. use an @parms file on the service command line and encrypt the @parms file using dbfhide -w or dbfhide -wm - see docs for more info).

permanent link

answered 13 Jul '19, 19:48

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

Comment Text Removed
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 13 Jul '19, 08:21

question was seen: 1,334 times

last updated: 14 Jul '19, 07:45