Cannot login to Foglight console: " The user account is locked" (4353073)

Cannot login to the Foglight Admin Console - getting the following error:

Error: Invalid username and/or password. Please try again.

OR

Error: The user account is locked.

Possible Causes:

1. Forgot the username/password for 'foglight' account. Or the person who knew the password has left the company. The solution for this cause is addressed in KB ID: 33046

2. If this is a new installation of the Foglight Management Server using an external database, where the database username and/or password has been changed between the installation and the actual login. The solution for this cause is addressed below.

Solution to Cause 2:

For a fresh installation of the FMS against an external database, it is important to run the database scripts AFTER the FMS installation and not before.

1. Make sure the installation directory is empty.
2. Install Foglight and under Foglight database account specify the database user which the FMS will use. The database scripts used to populate the database with Foglight schema will be created based on this username/password.
3. Ensure that the right hostname or IP address (DB Host) and the database SID have been specified, when defining the database that you will use.
4. Select the option to setup your database later.
5. Once the installation is complete, run the database scripts - created during the installation - against the external database.
6. Start the FMS and allow it a few minutes to start up completely.
7. Login with the foglight user with the password specified during the installation.