question

yuanhuihua avatar image
yuanhuihua asked

Database Master Key Error

In sys.transmission_queue is showing the transmission_status with error. "The session keys for this conversation could not be created or accessed. The database master key is required for this operation." I have a Master Key in the database, and I do execute also: alter master key add encryption by service master key but there is an exception: Msg 15581, Level 16, State 3, Line 1 please create or open the master key in database before execute the operating. help me ! thank you Regards
encryptionqueue
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
Did you do as the later error message suggests (Open the key that is): OPEN MASTER KEY DECRYPTION BY PASSWORD = 'a password' ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY CLOSE MASTER KEY
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.