locked
Is there a way to decrypt an password that is saved in SQL Server syslogins RRS feed

  • Question

  • I would like to know if there is way through which one can decrypt a password in the syslogins.

     

    Please let me know what all are the possibilities to decrypt.

    Saturday, December 24, 2011 4:58 PM

Answers

  • I would like to know if there is way through which one can decrypt a password in the syslogins.

     

    SQL Server does not encrypt login passwords.  The passwords are hashed and therefore cannot be reverse engineered in to original value.

     

    --

    Happy Holidays,

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Proposed as answer by Alex Feng (SQL) Sunday, December 25, 2011 12:16 PM
    • Marked as answer by Peja Tao Monday, January 2, 2012 7:14 AM
    Saturday, December 24, 2011 6:30 PM
  • Is there are reason you are actually wanting to do this? I am guessing it might be because you are wanting to move logins with passwords -yes?

    If so you dont need to worry about want the actual password is and can use the following stored procedure to script out your logins and hashed passwords.

     

    http://support.microsoft.com/kb/918992/


    Regards,
    Mark Broadbent.

    Contact me through (twitter|blog)

    Please click "Propose As Answer" if a post solves your problem
    or "Vote As Helpful" if a post has been useful to you
    • Marked as answer by cadarsh88 Wednesday, March 21, 2012 12:54 PM
    Tuesday, December 27, 2011 12:34 PM

All replies

  • I would like to know if there is way through which one can decrypt a password in the syslogins.

     

    SQL Server does not encrypt login passwords.  The passwords are hashed and therefore cannot be reverse engineered in to original value.

     

    --

    Happy Holidays,

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Proposed as answer by Alex Feng (SQL) Sunday, December 25, 2011 12:16 PM
    • Marked as answer by Peja Tao Monday, January 2, 2012 7:14 AM
    Saturday, December 24, 2011 6:30 PM
  • Is there are reason you are actually wanting to do this? I am guessing it might be because you are wanting to move logins with passwords -yes?

    If so you dont need to worry about want the actual password is and can use the following stored procedure to script out your logins and hashed passwords.

     

    http://support.microsoft.com/kb/918992/


    Regards,
    Mark Broadbent.

    Contact me through (twitter|blog)

    Please click "Propose As Answer" if a post solves your problem
    or "Vote As Helpful" if a post has been useful to you
    • Marked as answer by cadarsh88 Wednesday, March 21, 2012 12:54 PM
    Tuesday, December 27, 2011 12:34 PM