Users with sso_role can configure Adaptive Server to use unattended start-up mode by setting:
sp_configure ‘automatic master key access’, 1
In this mode, Adaptive Server accesses master keys, even if their passwords are not present in server memory, by reading and decrypting the master key encryption keys from the master key start-up file. To use unattended start-up mode, you must also create automatic_startup key copies for the master key and dual master key in the database.
