troubleshooting Question

Encrypt/Decrypt in VB.net/SQL Server

Avatar of whosbetterthanme
whosbetterthanmeFlag for United States of America asked on
Visual Basic.NETEncryptionMicrosoft SQL Server 2005
3 Comments1 Solution1047 ViewsLast Modified:
I have a need to allow a user to store sensetive data into a table where only they can understand the data, and no developer or admin could read it and decrypt it without a Key.

Here's how it would work:

From a VB.net app:
They enter a value they want to store (say Hello Word!) and a Key (say 123). That key is used to encrypt the data. The Hello World! data is now stored in a table in SQL as an encrypted string.

Now in order to decrypt the string into plain text so they can read it again, they would have to use the Key again (123).

How is this possible?

The reason for this is that I do not want anyone to be able to understand the data stored, but the user needs to be able to read it only if they have the Key. The Key should not be stored in code, or anywhere but entered in each time.

ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
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 1 Answer and 3 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