locked
How to Check the old password of a SQL User RRS feed

  • Question

  • I have created a user in Sql 2008 and forgot the password, I have SA access, I can reset the password but I want to Know the password of users

    Anyone who know how to check the password please let me know.

     
    Saturday, November 9, 2013 4:59 PM

Answers

  • I have created a user in Sql 2008 and forgot the password, I have SA access, I can reset the password but I want to Know the password of users  

    This is not possible because SQL Server does not store the password; only a hash of the password is stored.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    Saturday, November 9, 2013 5:29 PM
  • Assaid, you only have a hash.

    That hash is non-reversable, by nature, but of course you could run a brute-force attack on the hash or use rainbow-tables.

    Naturally this forum isn't a place to find out how to crack passwords though ;)


    Andreas Wolter | Microsoft Certified Master SQL Server

    Blog: www.insidesql.org/blogs/andreaswolter
    Web: www.andreas-wolter.com | www.SarpedonQualityLab.com

    Sunday, November 10, 2013 11:08 AM

All replies