Hi All ,

I have some issue to create database master key in SQL server 2012.

I have typed this command below:

USE master 
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'passwordbypolicy'

This is the error I got:

Msg 33094, Level 16, State 1, Line 2
An error occurred during Service Master Key decryption

Can somebody help.

Thanks ,

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/29886005-8604-4385-9af9-975c4828dd26/msg-15466-an-error-occurred-during-decryption

This article is pointed to different issue. My issue is the database master key.

Any other suggestion.


Thanks,

Below is the link for it:

http://msdn.microsoft.com/en-us/library/ms174382.aspx

Please be careful on your password part as there are some norm attached to it.

Also if it is giving you any more issues better clean your instance and try again. In some cases it doesn't  work as we might forget something to remove completely.

Hi Santosh,

I'm having the same issue. Unless I'm missing something, the link you referenced does not give solution to the issue above.