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
LVL 1
Moti Mashiah.NET DeveloperAsked:
Who is Participating?
 
Moti Mashiah.NET DeveloperAuthor Commented:
Solved the issue recreated the database masterkay.
0
 
plusone3055Commented:
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
0
 
Moti Mashiah.NET DeveloperAuthor Commented:
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...
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Moti Mashiah.NET DeveloperAuthor Commented:
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
0
 
Moti Mashiah.NET DeveloperAuthor Commented:
Please , anybody can help with the above.
0
 
Moti Mashiah.NET DeveloperAuthor Commented:
Thank You very much.
0
 
Moti Mashiah.NET DeveloperAuthor Commented:
I solved the issue by myself.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.