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 ...
15th July 2011, 11:29 AM #1
- Rep Power
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.
IDG Tech News
15th July 2011, 11:33 AM #2
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.
15th July 2011, 11:45 AM #3
Have you spoken to the LEA support team.
15th July 2011, 12:14 PM #4
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.
15th July 2011, 02:29 PM #5
- Rep Power
Same process to reset SA password for Express SQL as well.
Originally Posted by K.C.Leblanc
By Gerry in forum Hardware
Last Post: 3rd August 2011, 08:04 AM
By openaccess in forum MIS Systems
Last Post: 15th June 2011, 01:23 PM
By speckytecky in forum Mac
Last Post: 30th September 2008, 03:28 PM
Last Post: 19th July 2006, 01:48 PM
By Irazmus in forum Hardware
Last Post: 9th February 2006, 07:44 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)