"Cannot find the object "CHECKLIST_ITEM" because it does not exist or you do not have permissions" error when upgrading Web Help Desk

The following error message can be seen in WHD logs when an upgrade fails:

SQL Error message com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "CHECKLIST_ITEM" because it does not exist or you do not have permissions.'

db_owner permission is needed on the WHD tables.

Note: Secure database backup before making any changes to the backend

1. Stop Web Help Desk.
2. Access the database via MSSQL Management Studio.
3. Check the database and confirm if the table appears db_owner instead of dbo.
4. Once confirmed, update the db_owner permission to dbo.
5. Open Object Explorer and navigate to your table.
6. Right-click the table and select Design.
7. Press F4 to open the Properties window.
8. In the Schema field, select the desired schema from the dropdown menu.
9. Save the table (Ctrl + S) or close the design tab and click "Yes" when prompted to save changes

You may also alter the schema using a SQL query:

-- 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.

ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_ITEM
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE_AUDIENCE
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE_ITEM

ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_ITEM
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE_AUDIENCE
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE_ITEM
ALTER SCHEMA dbo TRANSFER db_owner.CONDITION_ARG_DICTIONARY
ALTER SCHEMA dbo TRANSFER db_owner.CONDITION_ARG_NAME
ALTER SCHEMA dbo TRANSFER db_owner.CONDITION_ARG_TYPE
ALTER SCHEMA dbo TRANSFER db_owner.OBJECT_EDITING
ALTER SCHEMA dbo TRANSFER db_owner.PASSWORD_RESET