troubleshooting Question

Encrypt/decrypt string data stored within sql server 2008

Avatar of rito1
rito1 asked on
C#ASP.NETMicrosoft SQL Server 2008
14 Comments3 Solutions2920 ViewsLast Modified:
Hi All,

I am pretty new to encryption, as to date I have only had to hash password data without the threat of it being decrypted.

I have done some top level research and understand that there are different algorithms available including both symmetric and asymmetric, and that the .net framework provide excellent security classes.

Within my current solution I have been asked to encrypt only certain table columns within sql server so that the data can only be decrypted by the end user when requesting the data from the asp.net web forms interface.

Can anyone share with me examples or helper class that will provide a sound encryption method that will stop even the nosey web developer from decrypting an end users data?

Should I be encrypting/decrypting using sql server or is it better to using C#?

Thanks in advance for you help and happy new year to you all!

Rit
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 14 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros