none
SQL 2012 database master key

    Question

  • 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 ,

    Monday, April 21, 2014 1:03 AM

All replies

  • http://social.msdn.microsoft.com/Forums/sqlserver/en-US/29886005-8604-4385-9af9-975c4828dd26/msg-15466-an-error-occurred-during-decryption
    Monday, April 21, 2014 7:32 AM
  • This article is pointed to different issue. My issue is the database master key.

    Any other suggestion.


    Thanks,
    Monday, April 21, 2014 1:39 PM
  • 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.


    Santosh Singh

    Wednesday, June 11, 2014 8:31 AM