Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1146
  • Last Modified:

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
0
Moti Mashiah
Asked:
Moti Mashiah
  • 6
1 Solution
 
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
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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:
Solved the issue recreated the database masterkay.
0
 
Moti Mashiah.NET DeveloperAuthor Commented:
I solved the issue by myself.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now