Cannot Decrypt Using Certificate
I have an encryption certificate set up for my DB. All the fields i'm trying to encrypt are varbinary(128). I inserted a few rows using the certificate to encrypt. The data appears to be encrypted. here is a sample of what on column/row looks like:
0x8F3CBF38BB459DB15DE11402
That is my credit card number field
However, when i attempt to decrypt it i get NULL. What am i doing wrong? Below is the query i'm using to decrypt
0x8F3CBF38BB459DB15DE11402
That is my credit card number field
However, when i attempt to decrypt it i get NULL. What am i doing wrong? Below is the query i'm using to decrypt
Select CONVERT(VARCHAR(50),DecryptByCert(Cert_ID('InfinityCertificate'),CreditCardNumber)),
CONVERT(VARCHAR(50),DecryptByCert(Cert_ID('InfinityCertificate'),ExpMonth)),
CONVERT(VARCHAR(50),DecryptByCert(Cert_ID('InfinityCertificate'),ExpYear))
from ReservationRequest
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER