MIS Systems Thread, Sysman user account on SIMS/Sqlserver in Technical; Hi,
i've just been given a reindex patch to run by Capita which needs to be run under the Sysman ...
25th May 2012, 10:37 AM #1
- Rep Power
Sysman user account on SIMS/Sqlserver
i've just been given a reindex patch to run by Capita which needs to be run under the Sysman user account (not SA).
It looks like when the DB software was installed no one kept a note of this password ( cant find anyone who know it) however looking at the ESSupgrade software there's a utility to rest the sysman password using the SA account - so I think I'm OK there.
My question is ...
a) is there anything SIMs uses in the background which would be affected by a password change on the Sysman account?
b) can I run the reindex patch at a quiet time but in working hours i.e. not having to get everyone off the system?
any guidance gratefully received.
25th May 2012, 10:50 AM #2
I don't have a sysman account for SIMS only FMS.
I actually think the Sysman account is just an account with permissions to everything within SIMS. I just use the admin account when I install one off patches and fixes from Crapita
The SA accounts has special weird permissions.
25th May 2012, 10:55 AM #3
if you were setup by county the password was setup using a formula. I'm reluctant to post our formula sorry but I'm sure other counties used the same formula as I've seen it outside of Dorset. Maybe they all went to the same training?
27th May 2012, 02:58 PM #4
Resetting the password should be okay, but for running the patch, i'd want to make sure everyone is out of the system to be safe. Plus they will recommend that too as well as taking a backup.
@chazzy2501 - i knew that happened in northants, didn't realise the extent of the problem! I even recall because they couldn't be bothered to remember the formula (which actually wasn't very hard at all!) they coded it, into one of their system utilities as part of the install.
By gmj in forum Netbooks, PDA and Phones
Last Post: 15th May 2012, 07:06 AM
By techie211 in forum Thin Client and Virtual Machines
Last Post: 16th November 2011, 12:29 PM
By Number6 in forum MIS Systems
Last Post: 13th April 2011, 07:17 AM
By tosca925 in forum How do you do....it?
Last Post: 8th June 2007, 03:15 PM
By secman in forum Windows
Last Post: 27th September 2006, 02:31 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)