Post reply

Can you recover SQL Authentication password?

  • August 26, 2012 at 9:41 am

    #260550

    All,

    If a user forgot his/her SQL Authentication password, is there anyway a DBA can recover that password, rather than resetting the password? Please advise.

    Thanks,

    SueTons

    Regards,
    SQLisAwe5oMe.

  • August 26, 2012 at 9:48 am

    #1530117

    No. SQL Server password is one-way encryption (Hash algorithm).

  • August 26, 2012 at 10:47 am

    #1530119

    Resetting the password is the proper procedure for this.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • August 26, 2012 at 11:20 am

    #1530122

    Any password system where you can retrieve the original password is a weak one. Passwords should never be stored using reversible encryption.

    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

  • August 26, 2012 at 11:43 am

    #1530125

    Ok. Thanks for all your inputs.

    SueTons.

    Regards,
    SQLisAwe5oMe.

Viewing 5 posts - 1 through 4 (of 4 total)

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