How To: Reset the Admin (1) user in NAM with SQL Studio
If you cannot login to New Aloha Manager (NAM) because of a password issue, you can edit the Employee SQL table to be able to get back in.
First, you need to have SQL Server Management Studio Express installed.
- Open SQL Server Management Studio Express and then click “Connect”.
- Expand the Databases and open CFCStandaloneDB.
- Select Tables and open the “Employee” table. The top line is for the “1” admin user.
- First, change the BOHPassword field to “NULL” and make sure the BOHPasswordStatus and FailedLoginCount is also set to 0.
- Finally, towards the end locate the BOHPasswordHash field and paste in the following: $5$nvD2w2wD2/Phy1Sf$0w4C69qO5MrLIOfkKn5J3ujk0dRyxRfGBpJ0S8MGen9 and then close SQL Server Management Studio Express. ( $5$nvD2w2wD2/Phy1Sf$0w4C69qO5MrLIOfkKn5J3ujk0dRyxRfGBpJ0S8MGen9 represents the password “t#sty66qq”. )
- Login to New Aloha Manager with the username of “1” and the password of “t#sty66qq”. It should allow you to login and may make you create a new password depending on the situation.
You can also use this trick on any employee in the system.