locked
Decrypt Password using MD5 algorithm in sql server RRS feed

  • Question

  • HI...

    Any one please give the query to Decrypt password field using MD 5 algorithm in sq l server 

    Thanks


    Thursday, October 17, 2013 12:11 PM

Answers

  • For what it's worth, you can't decrypt MD 5 hashed passwords. If you want to check that a user has typed in a password correctly, you use MD5 to hash their input and then compare the result to the value stored in the DB. 


    • Proposed as answer by Tom Phillips Thursday, October 17, 2013 2:56 PM
    • Marked as answer by Allen Li - MSFT Sunday, October 27, 2013 11:07 AM
    Thursday, October 17, 2013 2:30 PM

All replies

  • Hi

    your request is about SQL server. Please post your question in specific forum

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Thursday, October 17, 2013 1:22 PM
  • For what it's worth, you can't decrypt MD 5 hashed passwords. If you want to check that a user has typed in a password correctly, you use MD5 to hash their input and then compare the result to the value stored in the DB. 


    • Proposed as answer by Tom Phillips Thursday, October 17, 2013 2:56 PM
    • Marked as answer by Allen Li - MSFT Sunday, October 27, 2013 11:07 AM
    Thursday, October 17, 2013 2:30 PM
  • You cannot reverse MD5.  MD5 is specifically designed to prevent this from being done.

    Please see:

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

    Encryption algorithms define data transformations that cannot be easily reversed by unauthorized users.

    Thursday, October 17, 2013 2:59 PM