There may be times when a customer has forgotten or lost their AuthAnvil "Master Admin" password, and will need tohave it reset.
This is NOT something to take lightly.
Before we consider resetting the password we must answer yes to all the following questions:
Does the person making the request have authority to have the password reset? If not, we must obtain approval from the account owner, or a senior executive of the account, before continuing.
Does the person making the request have administrative access to the SQL Server where the AuthAnvil database is installed? We require this to reset the password.
Is there an official case reported in Zendesk assigned to this company, by this person?
If all answers to the above questions are Yes, then you can proceed.
Before doing a Master Admin Password reset
There are some cases where the customer believes that they need the master admin passwordreset, but they are actuallyunable to log ondue to other issueswithin AuthAnvil; oftendatabase connectivity issues, so we need to troubleshoot before we do the reset.Troubleshooting this scenario isas simple as having the customer attempt to log in using the master admin passwordand then checking the AuthAnvilevent log under event logs.If there are no errors or warnings in the event log from thelogon attempt, then this is a legitimatemaster admin password failure and it needs to be reset.
Ifyou recieve a database connectivity failureerror,thentroubleshoot using the AuthAnvil Web ConfigEditor (seeAppendix C ofhttp://www.scorpionsoft.com/docs/authanvil/install-guide). Ifyou receive the error "Logon Master admin failed. You may only log on as Master Admin from the local machine." (AuthAnvil 4.0 and later)
Resetting the Master Admin Password (AuthAnvil 5.x, 4.x)
Please follow the instructions in the macro
AuthAnvil --> 2FA --> Reset 2FA Master Admin Password and Close
Older Version: Resetting the Master Admin Password (AuthAnvil 3.5 and earlier)
Step 1 - Log into SQL Server
Open SQL Management Studio (or Express)
Connect to the SQL Server as an administrator
Step2 - Open the AuthAnvil database
On the left side of the treeview, expand Databases.
Step3 - Reset the password
Select dbo.MasterAdmin and open for editing
In the Password column copy the existing hashed password to notepad
Replace the value in the Password column with 'AuthAnvil' (without the quotes)
Step4 -Edit the AuthAnvil Configuration Wizardapp settings
In notepad, open %PROGRAMFILES%\Scorpion Software\AuthAnvil\AuthAnvilConfigurationWizard\AuthAnvilConfigurationWizard.exe.config. Note, if running on an operating system which supports UAC, you will need to elevate notepad to administrative levels.
In the "AdminPassSet" key, change the value from "1" to "0".
Step5 -Change the password
Start the AuthAnvil Configuration Wizard.
Enter in the AuthAnvil database settings, and the new Master Admin password.
Complete the wizard (just hit Next all the way through).
Step6 -Close Case
At this point, the Master Admin password is reset. If you want to see if it was actually the same master password, simply reopen the Password column in the database and compare the hash with what is currently in the clipboard/notepad. If they do, then you know the password was fine, and chances are the problem was a password reset in the AuthAnvil username. Either way, close notepad as you don't need the hashed value anymore.
Update the case in Zendesk as Solved.