asked on

SQL Service Master Key Encryption Help

Hi Guys ,

I have some issue to generate key for my databases. in my understanding the Hierarchic works as follow:

service masterkey -> Database masterkey -> and then you can generate key to your databases.

In my case I see just the "service masterkey" I assume that I have to create the master databasekey to solve this issue. I used this command below:

USE <master>
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<Password>'

and I got this error:

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

see attachment the key I have now.
masterkey.jpg

plusone3055

remember that the password that you use must adhere to the windows password standards on the machine that is running SQL..

so if windows requires a password that is x amount of characters and includes this and that, then the password you use in your statement must also follow those guidelines

Moti Mashiah

ASKER

Yes , the password follow by the policy. I typed many other password all of them was by policy requirement and still it is the same issue.

Any other thought...

Moti Mashiah

ASKER

let's say my policy says at least 6 characters and at least one capital.

soo

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

error I get:

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

Moti Mashiah

ASKER

Please , anybody can help with the above.

Moti Mashiah

ASKER

Thank You very much.

ASKER CERTIFIED SOLUTION

Moti Mashiah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Moti Mashiah

ASKER

I solved the issue by myself.