fjmorales (12/9/2009)

---

I created a MK and a Certificate to encrypt data and it works fine on the development server but once I moved the DB to the production server decryptbycert returns null.

Any idea?

I hope you've taken a backup of Service Master Key also and restored the same on the Prodn. along with the certificate?

If not, kindly restore the Service Master key on prodn. and then again restore the certificate on prodn.
& then Try again.

open master key decryption by password = 'WriteYouOriginalPasswordHere'
alter master key add encryption by service master key
close master key