+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1

    Join Date
    Feb 2010
    Thank Post
    Thanked 0 Times in 0 Posts
    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.


  2. #2

    Join Date
    Nov 2009
    Thank Post
    Thanked 221 Times in 200 Posts
    Rep Power
    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.

  3. #3

    Join Date
    Jan 2008
    South West
    Thank Post
    Thanked 271 Times in 219 Posts
    Rep Power
    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?

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Saudi Arabia
    Thank Post
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    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.

+ Post New Thread

Similar Threads

  1. [Android Tablet] Can you have 'user accounts' on Android?
    By gmj in forum Netbooks, PDA and Phones
    Replies: 10
    Last Post: 15th May 2012, 08:06 AM
  2. same user account on multiple clients
    By techie211 in forum Thin Client and Virtual Machines
    Replies: 3
    Last Post: 16th November 2011, 01:29 PM
  3. [SIMS] New SIMS install not letting users log on
    By Number6 in forum MIS Systems
    Replies: 41
    Last Post: 13th April 2011, 08:17 AM
  4. Clear User accounts password attributes on mass.
    By tosca925 in forum How do you do....it?
    Replies: 2
    Last Post: 8th June 2007, 04:15 PM
  5. Replies: 4
    Last Post: 27th September 2006, 03:31 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