Admin password locked out. Email not configured.

If you've not yet set up a mail account within Front Office, and the admin account becomes locked out. You can still access the reset password if you have access to the SQL server.

First you will need to request a password reset for the admin account.

Then, access the SQL Server, and run the following script, you'll be able to pull the reset password from the database.

Replace <yourinstancename> with the name of your front office database when running the script.

select top 1 right(Body , 56)
FROM [<yourinstancename>].[dbo].[EMAILS]
Where Body like '%new password%' or Subject like '%new password%'
order by EmailID desc

The script will return the password in the query field, inside of <p> brackets.

eg </p><p>pTr566iTE</p></span></p>

In the above example, the password is pTr566iTE

Please note. This assumes that the email language used is english. If your Front Office system is set to a different language, you will need to change the 'new password' text to that of your language. If this fails, you can manually browse the dbo.emails records, and view the 'body' entry for the password. The section of the body should contain a password as mentioned in the section above.