• Yes.

    OPEN MASTER KEY DECRYPTION BY PASSWORD = 'xxxxxx' was successful.

    OPEN SYMMETRIC KEY XXX_KEY DECRYPTION BY CERTIFICATE XXX_CERTIFICATE is where we got the following error

    'an error occurred during decryption'

    Also got the same results for the test script posted by diogenes1331.

    When we ran it in our Prod server,we got 'AAA'. When we ran it in the Test server, we got NULL