FortiClient
FortiClient proactively defends against advanced attacks. Its tight integration with the Security Fabric enables policy-based automation to contain threats and control outbreaks. FortiClient is compatible with Fabric-Ready partners to further strengthen enterprises’ security posture.
jie
Staff
Staff
Article Id 355273
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($.'

 

  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.

 

Picture1.png

 

  1. 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

 

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

 

Picture2.png

 

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

 

Picture3.png

 

 

 

 

 

 

Contributors