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 ...
1st December 2010, 09:26 AM #1
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.
1st December 2010, 09:57 AM #2
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!
1st December 2010, 10:17 AM #3
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...
1st December 2010, 10:19 AM #4
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.
1st December 2010, 11:01 AM #5
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.
1st December 2010, 11:02 AM #6
Thanks for the info, I'd forgot about that!
By JonTMac in forum MIS Systems
Last Post: 4th August 2010, 01:26 PM
By link470 in forum Windows
Last Post: 4th September 2009, 10:08 PM
By sakwoya in forum Hardware
Last Post: 9th December 2008, 10:03 AM
By cookie_monster in forum Windows
Last Post: 20th May 2008, 05:13 PM
By beeswax in forum Educational IT Jobs
Last Post: 31st May 2006, 06:25 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)