+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, User passwords get reset every day in Technical; I have a SIMS install where the passwords seem to be getting reset every day. At first I thought it ...
  1. #1
    Arcath's Avatar
    Join Date
    Feb 2009
    Location
    Lancashire
    Posts
    974
    Thank Post
    102
    Thanked 116 Times in 101 Posts
    Rep Power
    74

    User passwords get reset every day

    I have a SIMS install where the passwords seem to be getting reset every day. At first I thought it was the backups causing it but if I run the script (which uses dbattach) the passwords remain intact.

    The other wierd thing is that the sysman password stays the same and all I do to fix it is login as sysman and reset the users password.

    Anyone know what could be causing this? As far as I know our backup script is the only regular thing talking to sims.

  2. #2


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,659
    Thank Post
    276
    Thanked 780 Times in 607 Posts
    Rep Power
    224
    I'd change my backup method for a couple of days - use a maintenance plan in SQL server, for example - because the thing that comes to my mind is the "hey, you detached the database incorrectly and all your passwords are reset" historical known issue for SIMS-based (as opposed to AD-linked) usernames and password.

    What version of SIMS/dbattach are you using? SQL version? When did it start happening?

  3. #3
    Grey-gear's Avatar
    Join Date
    Nov 2009
    Location
    Derby
    Posts
    483
    Thank Post
    36
    Thanked 64 Times in 50 Posts
    Rep Power
    25
    When the users login to the computer is the reset password box ticket in the bottom left corner

  4. #4
    Arcath's Avatar
    Join Date
    Feb 2009
    Location
    Lancashire
    Posts
    974
    Thank Post
    102
    Thanked 116 Times in 101 Posts
    Rep Power
    74
    Quote Originally Posted by pete View Post
    I'd change my backup method for a couple of days - use a maintenance plan in SQL server, for example - because the thing that comes to my mind is the "hey, you detached the database incorrectly and all your passwords are reset" historical known issue for SIMS-based (as opposed to AD-linked) usernames and password.

    What version of SIMS/dbattach are you using? SQL version? When did it start happening?
    I did a sims transfer to a new machine last wednesday and this last week its been happening.

    I'm using SQL Express 2008 and db attach from the sims spring 2012 release.

    I use the exact same script and setup in other schools with no problems although I did have the lost passwords issue here when doing the transfer.

    I've run the script now and its not caused the passwords to be lost

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,690
    Thank Post
    693
    Thanked 1,410 Times in 1,167 Posts
    Rep Power
    354
    It's as though your master db is being overwritten, every day! Try detaching and then reattaching the DB, which should kind of take a snapshot of the logins as they are, so do it after you've reset a few. If you get any errors they may indicate a cause.
    There must be a process that is doing something daily, or a permissions issue so the changes you make are not being saved.

SHARE:
+ Post New Thread

Similar Threads

  1. Getting User passwords
    By zag in forum Windows Server 2000/2003
    Replies: 12
    Last Post: 25th January 2011, 03:42 PM
  2. resetting a local user password
    By Arcath in forum Windows 7
    Replies: 16
    Last Post: 9th December 2009, 10:00 AM
  3. Changing a users password without remembering it!
    By acrobson in forum How do you do....it?
    Replies: 10
    Last Post: 23rd November 2007, 09:15 AM
  4. View user password in AD
    By timbo343 in forum Windows
    Replies: 10
    Last Post: 20th March 2007, 05:04 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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