Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, August 9, 2013 8:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 9:10 AM
Points: 170, Visits: 782
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..
Krishna
Post #1482789
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse