I have one problem with encrypting data at one server and decrypting that on other server.
We have Sql server 2008 Cluster on Win2K3 64 bit server. and client machines are 32 bit XP machines.
I also have a library that encrypt and decrypt data using AES 128 bit using RijndaelManaged class. I have registered this Dll in SQL Sever and using this dll at client application as well.
now problem is that when I encrypt the data at SQL Server using a fix key and IV, the encrypted data is not decrypted at client machine. It throws the error "Padding is invalid and cannot be removed."
Though when decrypting the same text at SQL Server end, it works fine.
How can this be achieved?