Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Exclamation Unanswered: sa password keep changing automatically

    I am working with MSDE, but some how the password for sa keep changing by itself. I can reset it by logging in windows authentication mode using osql, but the next day the password does not work again.
    Please give me some suggestions

    Mik

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    What other user/s have dbo permissions on the box? Running the profiler a night scanning tracing for 'audit login' and 'audit login change password' might be a good idea.

  3. #3
    Join Date
    Nov 2003
    Location
    San Francisco, CA USA
    Posts
    59

    kaiowas is right

    SA passwords don't change or reset automatically. As he suggests, look at (or enable) some logging that will let you see what's up. Also, see if there are any services that execute in the middle of the night that may have SA permissions. Are there any system restores or other kinds of things happening? It is unlikely that anything like that will be changing the password but it's something to look at.

  4. #4
    Join Date
    Jan 2006
    Posts
    23

    Having the same problem

    I recently installed sql server 2005 and have had problems resetting the sa password too, it instantly resets itself to a password 15 characters in length. Probably different than your problem but still ... it happens.

  5. #5
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Look at your check boxes under general for that user, specifically:

    Enforce password policy
    Enforce password expiration
    User must change password at next login

    I think some or all may be selected by default.

    one or more may be checked.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by mik724
    I am working with MSDE, but some how the password for sa keep changing by itself. I can reset it by logging in windows authentication mode using osql, but the next day the password does not work again.
    Please give me some suggestions

    Mik

    It's the Miracle Engine!!!!
    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.

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    How does he know it changes to a password 15 characters in length?

Posting Permissions

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