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

[jie]

Description	This article describes how to restore the EMS database master key by using SMSS
Scope	FortiClient EMS v7.0, v7.2.
Solution	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($.' 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. Use the below Syntax to restore the master key: USE master GO sp_control_dbmasterkey_password @DB_name = N'FCM_Default',  @password =N'wjUQ+w6fsP#eYk!/eC&3_GCn$4zb47}STyRtT($.' , @action = N'add' GO Once restored successfully, it shows the below output: If the master is already existing, it shows the below warning: