Encryption in SQl server

Ajay Patel

12y2.1kSQL

Hello,

Which algorithm is used for encryption / decryption in SQL Server ?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
Well, you certainly shouldn't use MD5 or SHA1 as these are basically hashing algorithms which provide one-way encryption. So, whilst you'd be able to encrypt the credit card numbers, you wouldn't be able to recover them.

DSA and AES are both symmetric encryption algorithms (i.e. they use the same key for both encryption and decryption) and so would be suitable for this task. However, of the two you should prefer AES (based on the Rijndael cipher) which is more modern and considered more secure than DSA.
0

Ajay Patel12y ago

Hello,
Thanks for reply.
Will you please help me to understand following problem :

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. The application stores encrypted credit card numbers in the database. You need to ensure that credit card numbers can be extracted from the database. Which cryptography provider should you use

1. DSACryptoServiceProvider

2. AesCryptoServiceProvider

3. MD5CryptoServiceProvider

4. SHA1CryptoServiceProvider

Biswa Pujarini Mohapatra12y ago
SQL Server allows administrators and developers to choose from among several algorithms, including DES, Triple DES, TRIPLE_DES_3KEY, RC2, RC4, 128-bit RC4, DESX, 128-bit AES, 192-bit AES, and 256-bit AES.

check this
http://technet.microsoft.com/en-us/library/ms345262.aspx
0