Reactivate the default admin account in WHD

The default admin of WHD is the first account created after the database Wizard prompt when the WHD was installed on a Server.
This article explains how to reactivate or reset the default admin account in Web Help Desk. It shows how to connect to the WHD database and run the database query update statement to clear the inactive status, reset failed login attempts, and restore the admin login.
Use this procedure when the default admin account is stored locally in the database and is inactive, locked, or inaccessible.
Please take note that this procedure is intended for locally managed WHD accounts, not LDAP-managed accounts.

NA

If your WHD System is on a Windows server and a PostgreSQL (embedded) database, please follow the instructions below to reset and deactive the default admin account:

1. Log in to your WHD Windows server.
2. Go to Start > Run > services.msc and check if Web Help Desk PostgreSQL Embedded Database is running. Start it if it's not running.
3. Browse to
   1. For WHD 12.8.1 and above: Go to C:\Program Files\WebHelpDesk\pgsql13\pgAdmin 4\runtime and run the pgAdmin4.exe as an admin
   2. For WHD 12.8.0 to 12.7.8: Go to C:\Program Files\WebHelpDesk\pgsql13\pgAdmin 4\bin and run the pgAdmin4.exe as an admin
   3. For WHD 12.7.7 and below: Go to: C:\Program Files\WebHelpDesk\pgsql9\bin and run the pgAdmin3.exe as an admin
4. On the pgAdmin window, go to File > Add Server
5. Add the following:
   • Name: WHDDB
   • Host: localhost
   • Port: 20293
   • Maintenance DB: postgres
   • Username: DB admin username
   • Password: DB admin password
6. Click OK.
7. Expand "Databases" > whd
8. Right-click on the WHD database and select Run Query

The default username of the WHD Default admin is "admin"

Unlock/Reset the Default User Admin account 

1. Unlock/Reset the Default Admin account through your Web Help Desk database by executing the SQL script below:
    

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

UPDATE TECH
SET USER_NAME='admin',PASSWORD='admin',USE_LDAP_AUTHENTICATION=0, INACTIVE=0, INCORRECT_AUTH_ATTEMPTS=0
where CLIENT_ID=1;

*NOTE:

- Command varies, for example for PostgreSQL can use UPDATE TECH    >

For Microsoft® SQL can use UPDATE dbo.TECH

    > MySQL: you can check the schema being used for tables

2. Log in to Web Help Desk using these Default Admin account credentials.

username: admin
password: admin

If the username "admin" is returning as non-existent, it is possible that the username was changed.
To check the username of the default admin:

1. On the database, naviagate to Server > Databases > whd > Schemas > table > Tech
2. Right click on the Tech table and click on "View/Edit Table" and click "Select All Rows"
3. This will show you the entire list of tech created in WHD.
4. The first row is the very first tech account, which is the default admin.
5. Scroll to the right and look for the Username column.
6. Once the username has been identified, follow the steps above.