Manager account locked out

I have just processed a database through the upgrade to 10.2.300.7 from 10.1.400.30. I have logged into the system using the manager account three times without issue. The system now states the manager accounts password has expired and needs to be reset. Obviously I must have missed a step. This database does not have a specific account for the Task Agent which I am about to create. I also do not have any issue logging into the database with SSO. If I try to reset the password I get an error that the system will not allow you to do this. Do any of you know how to modify this password, or will it require a call to tech support?

Yep had that happen because by default they set the Policy or something now. I have a fix. Let me find it.

Dang it, I cant find the SQL Script I saved… but in a Nutshell here is something quick… I just did it through SQL.

-- Set manager user to manager password
UPDATE Ice.SysUserFile SET Password = 'PdnCdntJTEbfFOoePs4QxV/nD4lndJGMFug64ojqiTYyVC75OYeQcA==' WHERE UserID = 'manager';
UPDATE Erp.UserFile SET PassWord = 'PdnCdntJTEbfFOoePs4QxV/nD4lndJGMFug64ojqiTYyVC75OYeQcA==' WHERE DcdUserID = 'manager';

UPDATE Ice.SysUserFile SET UserDisabled = 0 WHERE UserID = 'manager';
UPDATE Erp.UserFile SET UserDisabled = 0 WHERE DcdUserID = 'manager';

UPDATE Ice.SysUserFile SET PwdExpires = null WHERE UserID = 'manager';
UPDATE Erp.UserFile SET PwdExpires = null WHERE DcdUserID = 'manager';


-- Set print user to print password
UPDATE Ice.SysUserFile SET Password = 'yw5hbQvvtBuJEImKe9Qhdirposq0tZ5XpaC4h+fCiGHxB81O9xpIVw==' WHERE UserID = 'print';
UPDATE Erp.UserFile SET Password = 'yw5hbQvvtBuJEImKe9Qhdirposq0tZ5XpaC4h+fCiGHxB81O9xpIVw==' WHERE DcdUserID = 'print';
4 Likes

Here we go I saved it to GitHub Gists: Must have been just this query that unexpires it.

UPDATE Ice.SysUserFile SET PwdExpires = NULL WHERE UserID = 'manager'

SELECT PwdExpires, PwdExpiresDays, PwdLastChanged, * FROM Ice.SysUserFile;

I might have also set PwdLastChanged to GetDate()

4 Likes

Or you could unlock the admin account via Admin Console :wink:

6 Likes

@hkeric.wci You come through again! Thanks so much for the quick response! The first response worked perfectly.

@Bart_Elia Now you have me curious I was about to press enter here. So now i have to check this out.

Thanks to all!

I could have sworn I tried that, but it kept saying the Password Expired and never re-prompting me to try again. Kept locking up again, will need to confirm.

Yeah you have to change the “connect” as in Admin Console to a different account (with security rights) for that to work me thinks.

OK @Bart_Elia looks like I need more details. I don’t think that will work. How would you do this? When I checked it logged in using SSO it was not locked.

The rest does what @hkeric.wci mentioned but behind an easy button. That area of admin console does direct dB manipulation to build databases. So as long as you have dB access, you are fine.
If you don’t have dB access you have larger issues

2 Likes

Just wanted to say thanks, this was helpful.

Thank you so much