I have a sql Server 2005 sp4 server, in which on one of database i have encrypted one column(users password) by symmetric key. Now i am moving this database from this server to another SQL Server 2008 r2. but application is not able to login users,.
I have recreated masterkey,symmetric key and certificate on new server but still not able to decrypt the password column.
What to do and how.