+ 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
    980
    Thank Post
    103
    Thanked 117 Times in 102 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,705
    Thank Post
    285
    Thanked 788 Times in 615 Posts
    Rep Power
    226
    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
    529
    Thank Post
    40
    Thanked 73 Times in 57 Posts
    Rep Power
    29
    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
    980
    Thank Post
    103
    Thanked 117 Times in 102 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,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    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, 04:42 PM
  2. resetting a local user password
    By Arcath in forum Windows 7
    Replies: 16
    Last Post: 9th December 2009, 11: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, 10:15 AM
  4. View user password in AD
    By timbo343 in forum Windows
    Replies: 10
    Last Post: 20th March 2007, 06: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
  •