Reply To: Encryption Decryption in SQL Server 2005
Lincoln Burrows ~
Modified: September 10th, 2015 ~ ~ 1 Minute Reading
Kindly confirm whether you have passed the same KEY_SOURCE, ALGORITHM and IDENTITY_VALUE for creating the symmetric key in the new server.
If they are exactly the same values, then ideally it should work. If not, then try dropping the symmetric key and try creating it again with the values that are used in the first server.