Microsoft Enterprise Platforms Support: Windows Server Core Team
EPS Team Blogs
Product Team Blogs
Hello, my name is Manoj Sehgal. I am a Senior Support Escalation Engineer in the Windows group and today’s blog will cover “MBAM Setup fails with SQL TDE Error message”
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.
Open SQL Management Studio and execute the below command.
CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘Password1!’
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.
Take Backup of the certificate using the below article.
This key will be required to restore the MBAM Recovery and Hardware DB to an alternate server or in Disaster Recovery Scenario.
I hope this article will help everyone to get MBAM installed correctly on the servers.
Manoj Sehgal Senior Support Escalation Engineer Microsoft Enterprise Platforms Support
Will this affect other databases running on the database server?
Microsoft Consultant – Monitoring & Management | CDW
Phone: 469.587.0486 | Lync: 847.371.9859 | Mobile: 210.284.9048
The above command is missing some parameters. It should be as follows:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'yourPassword';
Working perfectly fine, thank you!
I created a Master Key Encryption with the same request.
Several computers has been added into this database.
Could you tell me if when we use this command a certificat is automaticaly created or i have to create it manually with another request.
Because to make a restore i saw that we must to use a certificat but i don't know where is the certificat.
I have to create it ?
Thank you for you help!