Technical Tip: How to restore master key if it is missing in the EMS database

The master key is used to encrypt the symmetric key and the symmetric key is used to encrypt user data stored in the database.

The password for decrypting the master key:

N'wjUQ+w6fsP#eYk!/eC&3_GCn$4zb47}STyRtT($.'

1. Download SMSS (SQL Server Management Studio), and open EMS database. The master key is per DB, so if it is missing from 'FCM' and 'FCM_Default' it is necessary to restore each of them.

2. Use the below Syntax to restore the master key:

USE master
GO
sp_control_dbmasterkey_password @DBSfpd_name = N'FCM_Default',  @password =N'wjUQ+w6fsP#eYk!/eC&3_GCn$4zb47}STyRtT($.' , @action = N'add'
GO

3. Once restored successfully, it shows the below output:

If the master is already existing, it shows the below warning: