How to make use of SMK to resolve column level encryption errors for DBS that are part of Always ON

preview_player
Показать описание
All the below errors can be resolved easily by watching the above video

Msg 15329, Level 16, State 30, Line 43
The current master key cannot be decrypted. If this is a database master key, you should attempt to open it in the session before performing this operation. The FORCE option can be used to ignore this error and continue the operation but the data encrypted by the old master key will be lost.

Msg 15313, Level 16, State 1, Line 41
The key is not encrypted using the specified decryptor.

Msg 15581, Level 16, State 7, Line 137
Please create a master key in the database or open the master key in the session before performing this operation.
Рекомендации по теме
join shbcf.ru