Create the master key for the database.
The master key:
- Can be used with the dual master key as a composite key to
provide dual control and split knowledge for all user-created keys. Alternatively,
the master key can be used as a composite key with a column encryption key’s
explicit password.
- Can be altered to add key copies. Master key copies provide
access to the dual-master key for unattended start-up, to support recovery of the
master key, and to allow users other than the base-key owner to set the encryption
password.
- In the left pane of the Administration Console, expand .
- Click Master Keys.
- Select New.
You see the Add Master Key wizard.
- Select the server and database where the encryption key is being
defined.
- Enter a password for the master key and confirm it.
- (Optional) Click Summary to verify your selected options.