Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
psangeetha
Yak Posting Veteran
95 Posts |
 Posted - 2009-05-06 : 09:47:43
|
| Hi all,We are facing this critical issue, I need some help from you experts. I ran the encryption and decryption procedures on prod db and created a new master key on prod db in March 2009. It all worked fine. Our client refreshed their test db with prod data last week. Now, after the refresh to the test db last week, we are unable to decrypt the data on test db. I tried dropping and recreating the master key on test, still the decrypt value returns NULL. Both test db and prod db are SQL Server 2005 running on different servers. I'm confident that I'm using the same master key for both. Could there be any other possible issues here??? We are able to decrypt fine on the PROD db. Just the test db, the decrypt returns NULL.Please give me your suggestions. Thank you very much. |
|
|
|
|
|
Decrypt issue