If you have another admin account then you can login as that user and reset the password or unlock the account using the admin front-end. If you don't then read on...
Fix locked accountUnlocking the account was achieved by doing the following.
- Login to the P6 apps server.
- Run adminpv.cmd from P6_HOME\p6.
- Login as privuser.
- Navigate to Configuration->Custom->Primavera P6 Configuration->Database.
- Right-click on Instance and select Reset login failures.
Fix lost passwordLogin to the database either as admuser or sys and run the following update statement.
update admuser.users set passwd = null where user_name = 'admin';You can now login as admin, leaving the password blank.
Now that we were logged in to P6 we were able to reset the admin password.