MBAM: Setup Fails with SQL Error - Error obtaining a certificate protected by the master key

Issue: You will receive an error when you try to install MBAM Program

SQL Error: Error obtaining a certificate protected by master key

A master key password is needed for the setup to complete the Transparent data encryption (TDE) in the SQL Server database. Please create a master key encryption and provide a secure password for it.

Resolution:

Open SQL Management Studio on server and execute the below command.

Use master

CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘Deskperts@123’

Note: Password is set as per password policies and in this case I have used “Password1!” for reference. You can use any password which meets your password policies.

Once you complete this step, go ahead and then check Pre-requisites on the MBAM Setup wizard.

Hopefully this article will help everyone to get MBAM installed correctly on the servers!!!!!!!