Post reply

MS SQL Username and Password Recovery

  • February 12, 2012 at 10:46 am

    #255533

    Hi, I need quick recovery of encrypted SQL passwords and change them to something that I will share at the end of the project. Any Ideas

  • February 12, 2012 at 2:11 pm

    #1446066

    Changing passwords is easy, a sysadmin can change passwords without knowing the old values. ALTER LOGIN...

    The hashed passwords however cannot be recovered. The hash is a one-way hash

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 13, 2012 at 3:04 pm

    #1446545

    GilaMonster (2/12/2012)

    Changing passwords is easy, a sysadmin can change passwords without knowing the old values. ALTER LOGIN...

    The hashed passwords however cannot be recovered. The hash is a one-way hash

    High quality hashed SQL Server passwords cannot (practically) be recovered. Low quality ones can be recovered trivially; medium quality ones can sometimes be recovered.

    Regardless, given the OP's intention of changing them, Gail is (as is often the case) spot on; just change them.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply