Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Oct 2004
    Posts
    91

    Unanswered: Display current password for user account

    Hi everyone -

    Is there a way to display the current password for a user account
    on SQL server 2000???

    thanks
    tony

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Question:
    Why would you want to do this?
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    No. If you are connected as a certain user, you must have known the password to begin with.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Congrats on your 2,500th post Crowley
    George
    Home | Blog

  5. #5
    Join Date
    Oct 2004
    Posts
    91
    Hi everyone,

    Georgev - because there are existing applications that are running that connect to this database.

    I cannot change the password without killing the legacy apps,
    but i need to have the password documented, other than in the head
    of the developer that left the company.

    take care
    tony

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Then your only option is to contact the developer and find out!
    George
    Home | Blog

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Are they stored unencrypted in the applications that use the login?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If the answer to Poots' question is "yes" then I retract my last statement
    George
    Home | Blog

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by alt-088
    Hi everyone -

    Is there a way to display the current password for a user account
    on SQL server 2000???

    thanks
    tony
    What type of security are you using?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Oct 2004
    Posts
    91
    sql server authentication security

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    FROM admin911 by Brian Knight

    Code Blue

    With SQL Authentication, SQL Server commonly stores passwords in clear text in the registry and in log files. This provides a large security hol;e for those who want to cause harm to your system
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Thanks, George. As to the quote, though, usually it is the front end applications that keep an unencrypted copy of the password. I have not seen SQL Server do that since a service pack for SQL 7.0 left an sa password in its log.

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brian said it's for sql 2k]


    I just never went looking
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Sep 2003
    Location
    Los Angeles
    Posts
    103
    Quote Originally Posted by Brett Kaiser
    Brian said it's for sql 2k]
    I just never went looking
    damn you brian
    aka "GDMI" and "GDMI." and "GDMI.." !!! wtf!

  15. #15
    Join Date
    Oct 2004
    Posts
    91
    so the answer is a resounding

    no

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •