Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of Moti Mashiah
Moti Mashiah🇨🇦

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

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of plusone3055plusone3055🇺🇸

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
Avatar of Moti MashiahMoti 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...
Avatar of Moti MashiahMoti 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
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of Moti MashiahMoti Mashiah🇨🇦

ASKER

Please , anybody can help with the above.
Avatar of Moti MashiahMoti Mashiah🇨🇦

ASKER

Thank You very much.
ASKER CERTIFIED SOLUTION
Avatar of Moti MashiahMoti Mashiah🇨🇦

ASKER

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of Moti MashiahMoti Mashiah🇨🇦

ASKER

I solved the issue by myself.
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.