Encryption Decryption in SQL Server 2008

Hi mdali,

You need to follow the article step by step. There is already method provided to decrypt the string. So you need to use the same key to decrypt.

Hi dharmendr,

Thanks for your reply.Iam able to decrypt in c# for the encrypted string  but I would like to decrypt  the same in sql server 2008 .Here i used AES algorithm.But any algorithm is fine for me like (Rsa or Aes etc).

Can you please provide solution on  this.

Hi mdali,

Refer the below query. You need to use the same key to decrypt the encrypted string.

DECLARE @Encrypt VARBINARY(200) 
SET @Encrypt = ENCRYPTBYPASSPHRASE('MAKV2SPBNI99212', 'abc')
SELECT @Encrypt EncryptedValue

SELECT CONVERT(VARCHAR(100),DECRYPTBYPASSPHRASE('MAKV2SPBNI99212', @Encrypt)) DecryptedValue

Output

EncryptedValue

0x01000000083E19A4BF8EAAF20B3B25092522E19439003A7D8FA816CD

DecryptedValue

abc