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:
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.