I
I
Ivan2015-01-06 18:22:49
SQL
Ivan, 2015-01-06 18:22:49

Decryptbykey returns an empty string. What could be the problem?

Good afternoon!
There was such a problem: the password encrypted with the encryptbykey function is stored in the database.
Applying decryptbykey to this field returns an empty string. Everything seems to be correct.
encrypted field varbinary (max), decrypted varchar (max), I open the key before the decrypt, but the string is still empty. I broke my whole head already)
SQL Server 2012

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question