Post reply

how to retrive a password for sql auth account

  • February 7, 2012 at 2:11 pm

    #250437

    Hello,

    How can to retrive a password for sql auth account

    Thank you

  • February 7, 2012 at 2:19 pm

    #1444136

    you cannot. simply reset the password to a new known value.

    Copy

    ALTER LOGIN Mary5 WITH PASSWORD = '<enterStrongPasswordHere>';

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 7, 2012 at 4:54 pm

    #1444231

    In SQL 2000 and early builds of 2005 you could get a memory dump and grab the information if that user was logged in, however the SQL team has secured things greatly since then and it's no longer an option.


    Shamless self promotion - read my blog http://sirsql.net

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

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