All geek questions in one place

SQL Server 2005 - Recovering an Encrypted Database on Another Server

I backed up the encrypted database (symmetric key / certificate) and restored it to another server.

Unfortunately, we have problems with decryption ... hoping someone can help.

In the restored db, I see the Symmetric key and certificate in SSMS, but when I try to open the key using cert (open symmet key KeyA decryption according to CertB certificate) I get after a very descriptive error:

Msg 15466, Level 16, State 1, Line 1 An error occurred while decrypting.

Any ideas?

Thanks in advance.

+3
source share
3 answers

http://blogs.msdn.com/lcris/archive/2007/11/16/sql-server-2005-restoring-the-backup-of-a-database-that-uses-encryption.aspx :

" , , - (DbMK) - (SMK), , DbMK, , . , SMK- DbMK, :

= '' ALTER MASTER KEY ADD ENCRYPTION CLOSE MASTER KEY

- , . , , , , . , , , , DbMK "

+3

, , , , , . , , . , .

, .:)

0

http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/34c9c35c-2d08-4873-abfd-aae40240dfe7/?prof=required

, 2 /

You can perform recovery from the target server using UNC, you do not need to copy the file.

0
source

Source: https://habr.com/ru/post/1698366/

More articles:


All Articles