+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Migration - no passwords working (none with Systems Manager access) [Solved] in Technical; As above, help! The support team have said call professional services but they aren't open just yet, no accounts with ...
  1. #1
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,226
    Thank Post
    161
    Thanked 150 Times in 135 Posts
    Rep Power
    104

    Migration - no passwords working (none with Systems Manager access) [Solved]

    As above, help! The support team have said call professional services but they aren't open just yet, no accounts with sysman access are working... a few are but the vast majority are not.

    This is after the SQL Server 2008 upgrade.

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,115
    Thank Post
    380
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    How many accounts do you have that need sysman access??? (I assume you mean SIMS)

    Try (after a backup) detaching and reattaching the database, this can often 'reattach' the password to accounts.

    Obviously, I am not SIMS so don't take my word for it!

  3. #3
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,226
    Thank Post
    161
    Thanked 150 Times in 135 Posts
    Rep Power
    104
    Sorry Systems Manager access is to allow access to the individual users, the data manager is off who does this area... so i'm stuck, i had access on my account but my pw doesn't work, it looks to have been removed. If I have access I can reset everyone elses - happy days, bit of extra admin but I can deal with that.

    The joys of things you aren't supposed to know about but support...


    RESOLVED!

  4. #4

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,115
    Thank Post
    380
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    Resolved? How did you out of interest?

    As a future safeguard (sort of) I always kept a backup emergency account that a team of people might be abel to access, or even better, with the username and password securely stored (ie in a safe) in case of emergency that, say the dept head, could go to and get.

  5. #5
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,226
    Thank Post
    161
    Thanked 150 Times in 135 Posts
    Rep Power
    104
    A tool on the capita website allows you to reset the sysman username which has the access to Systems Manager, from that I reset my own and reset everyone elses.

    The tool is called ESSUpgrade and is on Capita Education Support Services - you need to know your DBs SA password to do it.

  6. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,115
    Thank Post
    380
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    Thanks for the info, I'd forgot about that!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Scheduled Task not working after sql2008 migration.
    By JonTMac in forum MIS Systems
    Replies: 3
    Last Post: 4th August 2010, 12:26 PM
  2. Replies: 3
    Last Post: 4th September 2009, 09:08 PM
  3. [solved] RM Mobile One Bios Access - f2
    By sakwoya in forum Hardware
    Replies: 2
    Last Post: 9th December 2008, 09:03 AM
  4. Disable LAN Manager passwords
    By cookie_monster in forum Windows
    Replies: 2
    Last Post: 20th May 2008, 04:13 PM
  5. Systems Manager
    By beeswax in forum Educational IT Jobs
    Replies: 0
    Last Post: 31st May 2006, 05:25 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
  •