Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Msg 15320, Level 16, State 2, Line 1 Expand / Collapse
Posted Friday, August 9, 2013 8:13 AM


Group: General Forum Members
Last Login: Tuesday, August 23, 2016 9:47 AM
Points: 195, Visits: 997
I have refreshed DB 'A' from server 'A' to server 'B'..And ran these scripts But after running second step I am getting below specified error message.

open master key decryption by password = 'password';
alter master key regenerate with encryption by password = 'password';
close master key;

An error occurred while decrypting asymmetric key 'asym_key' that was encrypted by the old master key. The FORCE option can be used to ignore this error and continue the operation, but data that cannot be decrypted by the old master key will become unavailable.

Note [ is_master_key_encrypted_by_server=1 in sys.databases]

please let me know if you need any other details...

Thanks in Advance..
Post #1482789
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse