I have some string values that have been encrypted using the AesManaged class in C# then stored on a sql database as VarBinary values. I have access to the key (32 byte array) and initialization vector (IV)(16 byte array) that were used to perform the encryption.
What I would like to do now is decrypt the data straight from SQL-Server (2014) without having to pull the Varbinary data back into C# and then run it through the AesManaged Class again.
Is this even possible?
I have access to create keys and certificates on sql server as needed.
CLR is disabled on the Database. I asked the DBAs, they said no.
I found this answer and he says it's not possible, but he doesn't cite any documentation or anything.
Thoughts?