Tools
The default Administrator account cannot be deleted.
This article shows how to resolve an issue where the default Administrator account cannot be deleted from the technician interface
First published date
8/12/2019 2:05 PM
Last published date
8/12/2019 2:05 PM
Overview
When Web Help Desk is configured the first time, an administrator account is configured to navigate through Web Help Desk.
This very first admin account is the 'default admin' account in Web Help Desk, regardless if it is active or inactive.
This account cannot be deleted.
This very first admin account is the 'default admin' account in Web Help Desk, regardless if it is active or inactive.
This account cannot be deleted.
Product section
Web Help Desk
Resolution
Connect to the Web Help Desk SQL database
Navigate to the TECH table, and take note of the CLIENT_ID value of the default admin, and the new admin account to be set as the default
Run the SQL queries below
Query to remove the 'default admin' lock to the old admin account.
Query to set the 'default admin' lock to a new admin account. The CLIENT_ID value here should be of the new admin account
Log out from Web Help Desk and log back in.
You can now downgrade the default admin's account from an Admin type to Tech, or delete the admin account.
Navigate to the TECH table, and take note of the CLIENT_ID value of the default admin, and the new admin account to be set as the default
Run the SQL queries below
Query to remove the 'default admin' lock to the old admin account.
# Disclaimer: 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 LOCKED = 0 WHERE CLIENT_ID = 1;
Query to set the 'default admin' lock to a new admin account. The CLIENT_ID value here should be of the new admin account
# Disclaimer: 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 LOCKED = 1 WHERE CLIENT_ID = x; Where x = CLIENT_ID value of the new admin account
Log out from Web Help Desk and log back in.
You can now downgrade the default admin's account from an Admin type to Tech, or delete the admin account.