+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, Password Reset? in Technical; Most likely a dead end question, but is there ANY way at all to reset a SIMS password using some ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0

    Password Reset?

    Most likely a dead end question, but is there ANY way at all to reset a SIMS password using some kind of SQL command or other method rather than having to log into SIMS and doing it manually in Systems Manager?

  2. #2
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    I expect this is possible using one of the SQL stored procedures like sp_password. However, I don't think sp_password is a routine that Capita would recommend or support if it messed something up. Also with sp_password you'd have to be 100% sure you were getting the right account name and for that you'd probably have to go into the SQL management studio or similar and check the exact format of the account name you are going to reset. By that time you could have gone into system manager and done it.

    The built in way to do it is there for a reason I guess, although it is a bit cumbersome - hopefully System Manager 7 will make improvements in this area.
    Last edited by superfletch; 19th January 2011 at 09:16 AM.

  3. Thanks to superfletch from:

    Rawns (19th January 2011)

  4. #3
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    .... and Sysman7 is now on the horizon!

  5. Thanks to Sivadam from:

    Rawns (19th January 2011)

  6. #4

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,784
    Thank Post
    1,623
    Thanked 1,877 Times in 1,395 Posts
    Blog Entries
    2
    Rep Power
    422
    As a joke I would say "Drop * from *" would usually do the trick...lol

    I wouldn't mess with the database if I were you, it can get very ugly!

  7. Thanks to nephilim from:

    Rawns (19th January 2011)

  8. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Thanks for the feedback guys. I thought that would be the general consensus.

    Manual resetting it is then.

  9. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Don't mess with the DB!
    However, set your users up with a trusted connection i.e. single sign-on and you can then reset passwords through AD, or any other available password reset tool that is available for regular windoze users.

  10. Thanks to vikpaw from:

    Rawns (19th January 2011)

  11. #7
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    Don't mess with the DB!
    However, set your users up with a trusted connection i.e. single sign-on and you can then reset passwords through AD, or any other available password reset tool that is available for regular windoze users.
    If only it were that simple! I'm LA support, not based in a single school and unfortunately, it's that time to reset our SIMS administrator logins in each school.

  12. #8
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Quote Originally Posted by jinnantonnix View Post
    If you're not using Windows authentication, it's tricky (unless things have changed since I last looked at it).
    Yes, you can reset the password on the SQL side, and this will change the SQL server login password. However, SIMS has its own internal passwords which are used by the application, and this must be done using the SIMS client or a stored procedure.
    That's roughly what I was thinking but I didn't know how to put it into words.
    If the mighty G&T thought it was a minefield then leave well alone.

  13. Thanks to superfletch from:

    Rawns (19th January 2011)

  14. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by Rawns View Post
    If only it were that simple! I'm LA support, not based in a single school and unfortunately, it's that time to reset our SIMS administrator logins in each school.
    Maybe a batch file / vbscript to take away some of the typing/clicking, but it's probably as complicated as getting access and applying a stored procedure or doing it manually.

    The change password button on login works now i think? Glad to hear you're changing the passwords, as i know some places that kept them the same for years.

  15. Thanks to vikpaw from:

    Rawns (19th January 2011)

  16. #10
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by jinnantonnix View Post
    Maybe it's got easier - it might be worth asking SIMS if there's a utility to do this. Let us know if you get any luck.
    This was the first route I took.

    Quote Originally Posted by Capita
    Thank you for your query. Unfortunately not, any passwords that need to be reset will have to be reset through System Manager.

  17. #11
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Change request logged: 1101-833333

  18. 2 Thanks to Rawns:

    jinnantonnix (19th January 2011), superfletch (20th January 2011)

  19. #12
    Ian_ICTDS's Avatar
    Join Date
    Jun 2009
    Location
    Warwickshire
    Posts
    70
    Thank Post
    11
    Thanked 15 Times in 12 Posts
    Rep Power
    13
    Hi All,

    I have a SQL script that we use in the office (I work for the LA) when we are testing data that schools send us. It sets the password of whatever user you like to whatever password you like.

    I personally would never use it on a live site for the reasons discussed above but I thought people might like to know how it’s done out of curiosity or for reasons we use it.

    There are two halves to changing the password. You have to set the record within the SIMS database and then you have to update the actual SQL user account. It gets a little tricky because SIMS encrypts the password it uses for the SQL user. Luckily there is a stored procedure to do this for us.

    Here is the script (Again, don’t use it on live sites):

    Code:
    Code removed following a request from a mod.
    Ian.
    Last edited by Ian_ICTDS; 19th January 2011 at 02:27 PM. Reason: Code removed

  20. Thanks to Ian_ICTDS from:

    jinnantonnix (19th January 2011)

  21. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by Rawns View Post
    Change request logged: 1101-833333
    strongly agreed. (+2)

    i don't think system manager 7 is going to do anything funky like this.

    how do you use your admin login? remote in to the system some how? do you have a windows log in to the school's network. I still think using trusted login would make it easier, as you can easily change the windows password.

  22. #14
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    We have our own network login set up in every school's AD that we support which we use for when we need to remote in to school. We use it mainly for server work (fixing backup issues, B2B issues, etc etc) but its also used on workstations for SIMS installs, upgrades etc as we have full admin rights. Our SIMS login is obviously set up in system manager in each school's SIMS system.

  23. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,382
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    I thought there was an option to set SQL logins to meet Windows requirements, aka expire??

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Password Reset
    By mhussain in forum Windows Server 2000/2003
    Replies: 2
    Last Post: 20th July 2010, 02:54 PM
  2. Self Service Password Reset
    By rh91uk in forum Virtual Learning Platforms
    Replies: 1
    Last Post: 8th June 2010, 10:30 AM
  3. FMS Password Reset
    By Sp0oK in forum MIS Systems
    Replies: 1
    Last Post: 5th February 2010, 10:16 AM
  4. Reset Sysman password
    By DreddMetal in forum MIS Systems
    Replies: 6
    Last Post: 27th April 2009, 08:34 PM
  5. reset admin password
    By fafster in forum Windows
    Replies: 11
    Last Post: 27th February 2008, 10:01 AM

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
  •