decrypt sql binary password to string password md5 in asp.net

Question

0.00/5 (No votes)

See more:

ASP.NET

decrypt sql binay password to string password in asp.net

Posted 10-Jan-12 23:58pm

goplappu

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-01-11T00:52:00

No, sorry, that doesn't make a lot of sense. But I will try to work out what you are trying to do...

MD5 doesn't have a password and can't be de-crypted. So what I think you are doing is working out the MD5 hash of a password, and storing it in an SQL Binary field.
Now, you want to either check if the user has entered the right password, or tell him what the password he entered is.

1) Check password. Do not attempt to work back from the SQL stored version to a string and compare them. Instead, generate the MD5 hash in exactly the same way that you did when you stored the password in the first place, and compare the two binary arrays. (there is a Tip covering some of this here: Password Storage: How to do it.[^]

2) Forget it. MD5 is not an encryption algorithm. It is a Hashing algorithm. The big difference is that encryption can be reversed: you can decrypt to get back to the one and only original. Hashing cannot - it is a one way process and you cannot get back to the one and only original from the MD5 value.