is any script I can run to decrypt password in sysxlogins?

Posted on 2009-02-10
Last Modified: 2012-05-06
I have user's name in sysxlogins but I can not tell the passowrd, it is encrypted.
I need to know the user password then I can give user to login application.

Please help this.
Question by:yrcdba7
    LVL 31

    Accepted Solution

    You can't it is one way hash algortim. You can try to use this hash as password hovever but you must skip encoding.

    LVL 39

    Expert Comment

    The password is not encrypted, it's hashed.  It can't be reversed.  If you need to give a user their SQL Login password, why not reset it?

    Author Comment

    you are right, it had reset for pwd.
    LVL 39

    Expert Comment

    Glad we could help.  Please close the question at your convenience.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now