• Thanks for your help.

    >>>What is the symmetric key encrypted with?

    >>>If it's a certificate or asymmetric key, are you able to open that key explicitly?

    The symmetric key is encrypted with a Certificate.

    No, I am not able to open the key. When I try to open the key with the statement:

    OPEN SYMMETRIC KEY SymKey

    DECRYPTION BY CERTIFICATE Cert

    I get the error

    Msg 15466, Level 16, State 1, Line 1

    An error occurred during decryption.

    I have also imported the Service Master Key from the original server and I still have the same problems.