+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, SIMs Admin Password Lost!! in Technical; We've been asked by a school to reset the SIMs Administrator Account password which has been lost. We've received a ...
  1. #1
    InspireICT's Avatar
    Join Date
    Dec 2010
    Location
    North London
    Posts
    111
    Thank Post
    17
    Thanked 6 Times in 6 Posts
    Rep Power
    9

    SIMs Admin Password Lost!!

    We've been asked by a school to reset the SIMs Administrator Account password which has been lost. We've received a patch from Capita to reset the password but that requires admin access to the SQL instance (or so I'm told). Can anyone give any guidance on how to go about this - knowledgbase articles etc.

    Thanks in advance.

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    The user is most likely "sa" password could be anything.

    EDIT: Is there a "trusted" option for login?
    Last edited by creese; 15th July 2011 at 11:46 AM.

  3. #3


    Join Date
    Jul 2007
    Location
    Rural heck
    Posts
    2,662
    Thank Post
    120
    Thanked 433 Times in 352 Posts
    Rep Power
    126
    Have you spoken to the LEA support team.

  4. #4
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    444
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    So it sounds like you need the SA (SQL admin) account to run the patch which resets the SIMS "Sysman" password - is this correct?

    If so then as @creese said if you have a trusted or mixed mode SQL installation then you can reset the SA password reasonably easily.

    With full SQL (not sure about express) you can reset it within the management studio.

    If you can't do that then you can do it through osql at the command line.

    I agree with @K.C.Leblanc that it's worth speaking to the LA Support team as they may have a record of it, or might have set up services (eg runtime backups) that use it.
    Last edited by superfletch; 15th July 2011 at 12:16 PM. Reason: @mention

  5. #5

    Join Date
    Mar 2010
    Location
    UK
    Posts
    175
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    17
    Quote Originally Posted by K.C.Leblanc View Post
    Have you spoken to the LEA support team.
    Same process to reset SA password for Express SQL as well.

SHARE:
+ Post New Thread

Similar Threads

  1. HP Officjet 7000 - Admin Password Lost
    By Gerry in forum Hardware
    Replies: 5
    Last Post: 3rd August 2011, 08:04 AM
  2. [SIMS] SIMS ISO Password
    By openaccess in forum MIS Systems
    Replies: 11
    Last Post: 15th June 2011, 01:23 PM
  3. Retriving lost mac admin password details
    By speckytecky in forum Mac
    Replies: 2
    Last Post: 30th September 2008, 03:28 PM
  4. Replies: 8
    Last Post: 19th July 2006, 01:48 PM
  5. New SIMS/Admin server
    By Irazmus in forum Hardware
    Replies: 6
    Last Post: 9th February 2006, 07:44 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
  •