Tools
How to Change Web Help Desk Schema using Microsoft SQL Server (MS SQL) as the Database
This article describes an issue when Domain Administrator or Group Administrator cannot create a user with a user path that should be made at the point of login automatically.
First published date
Last published date
Overview
In this issue, the Web Help Desk is unable to connect to MS SQL Server. When restarting the Web help Desk services, the Configuration Wizard opens the default browser and asks to configure the Database.
When trying to connect it's unable to read the Database data and seems a brand new setup. When proceed, getting an error:
EvaluateExpression failed: Next exception: SQL State:SO001 -- error code: 4902 -- msg: Cannot find the object "ACTION_RULE because it does not exist or you do not have permissions.
Product section
Cause
The WHD database from the MS SQL Server is not using the default schema [dbo], causing the application unable to recognize the database data.
Resolution
1. Current Database Backup of your Web Help Desk
2. Create a Server Snapshot
Implementation Steps:
1. Log in to MS SQL Server
2. Launched the SQL Server Management Studio
3. Select the Web Help Desk Database Container
4. Run the query 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.
ALTER Schema dbo Transfer currentschema. <table name>
For example, the current schema is Solarwinds as shown below:
5. Run the query below to change to dbo
-- 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 Solarwinds.HISTORY_ENTRY
ALTER SCHEMA dbo TRANSFER Solarwinds.INVALID_EMAIL_RECEIPT
ALTER SCHEMA dbo TRANSFER Solarwinds.JOB_TICKET
ALTER SCHEMA dbo TRANSFER Solarwinds.JOB_TICKET_ACTIVE_SESSION
ALTER SCHEMA dbo TRANSFER Solarwinds.JOB_TICKET_ASSET
ALTER SCHEMA dbo TRANSFER Solarwinds.JOB_TICKET_PART
ALTER SCHEMA dbo TRANSFER Solarwinds.LEASE_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.LOC_APPROV_TYPE_LOCATION
ALTER SCHEMA dbo TRANSFER Solarwinds.LDAP_CONNECTION
ALTER SCHEMA dbo TRANSFER Solarwinds.LOCATION
ALTER SCHEMA dbo TRANSFER Solarwinds.LOC_GENERIC_ATTACHMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.LOCATION_ADMIN_CONTACT
ALTER SCHEMA dbo TRANSFER Solarwinds.LOCATION_APPROVER_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.LOCATION_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.LOCATION_GROUP_CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.LOCATION_GROUP
ALTER SCHEMA dbo TRANSFER Solarwinds.LOCATION_TAX_RATE
ALTER SCHEMA dbo TRANSFER Solarwinds.LVL_ASSIGNMENT_HIST_ENTRY
ALTER SCHEMA dbo TRANSFER Solarwinds.LOGGER_SETTING
ALTER SCHEMA dbo TRANSFER Solarwinds.MANUFACTURER
ALTER SCHEMA dbo TRANSFER Solarwinds.MESSAGE
ALTER SCHEMA dbo TRANSFER Solarwinds.MODEL
ALTER SCHEMA dbo TRANSFER Solarwinds.PART
ALTER SCHEMA dbo TRANSFER Solarwinds.PART_ADD
ALTER SCHEMA dbo TRANSFER Solarwinds.MODEL_GENERIC_ATTACHMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.PART_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.PART_LOCATION_PART
ALTER SCHEMA dbo TRANSFER Solarwinds.PLUGIN_PREFERENCE
ALTER SCHEMA dbo TRANSFER Solarwinds.PO_ATTACHMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.PO_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.PO_ITEM
ALTER SCHEMA dbo TRANSFER Solarwinds.PREFERENCE
ALTER SCHEMA dbo TRANSFER Solarwinds.PRIORITY_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.PRIORITY_TYPE_LOCATION
ALTER SCHEMA dbo TRANSFER Solarwinds.PROBLEM_TYPE_COMPANY
ALTER SCHEMA dbo TRANSFER Solarwinds.PROBLEM_TYPE_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.PROBLEM_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.PROBLEM_TYPE_LOCATION
ALTER SCHEMA dbo TRANSFER Solarwinds.PURCHASE_ORDER
ALTER SCHEMA dbo TRANSFER Solarwinds.QUALIFIER
ALTER SCHEMA dbo TRANSFER Solarwinds.QUALIFIER_CONDITION
ALTER SCHEMA dbo TRANSFER Solarwinds.QUERY
ALTER SCHEMA dbo TRANSFER Solarwinds.READ_MESSAGE
ALTER SCHEMA dbo TRANSFER Solarwinds.REFRESH_FLAG
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_CACHE
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_GROUP
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_GROUP_DEPT_GROUP
ALTER SCHEMA dbo TRANSFER Solarwinds.ACTION_RULE
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_GROUP_LOC_GROUP
ALTER SCHEMA dbo TRANSFER Solarwinds.ACTIVE_SESSION
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_GROUP_TECH_GROUP
ALTER SCHEMA dbo TRANSFER Solarwinds.ADMIN_CONT_ROLE_CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_SCHEDULE
ALTER SCHEMA dbo TRANSFER Solarwinds.ADMIN_CONT_ROLE
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_SCHEDULE_CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.ADMIN_CONT_ROLE_PROB_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_SCHEDULE_HISTORY
ALTER SCHEMA dbo TRANSFER Solarwinds.ALERT
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_SCHEDULE_REPORT
ALTER SCHEMA dbo TRANSFER Solarwinds.APN_DEVICE
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_SCHEDULE_TECH
ALTER SCHEMA dbo TRANSFER Solarwinds.APPR_PROCESS
ALTER SCHEMA dbo TRANSFER Solarwinds.REPORT_VERSION_INFO
ALTER SCHEMA dbo TRANSFER Solarwinds.APPR_PROCESS_STEP
ALTER SCHEMA dbo TRANSFER Solarwinds.ROOM_CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET
ALTER SCHEMA dbo TRANSFER Solarwinds.ROOM_CLIENT_BULK_ACTION
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_BULK_ACTION
ALTER SCHEMA dbo TRANSFER Solarwinds.SERVICE_TIME_BLOCK
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_BULK_ACTION_ATTCHMNT
ALTER SCHEMA dbo TRANSFER Solarwinds.ROOM
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_BULK_ACTION_CHILD
ALTER SCHEMA dbo TRANSFER Solarwinds.SESSION_HIST_ENTRY
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_BULK_ACTION_CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.SMTP_SERVER
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_BULK_ACTION_PARENT
ALTER SCHEMA dbo TRANSFER Solarwinds.STATUS_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.STATUS_TYPE_CUST_FIELD_DEF
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.SUBSCRIBER
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_GENERIC_ATTACHMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.SUBSCRIBER_PLUGIN_PREF
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_HISTORY
ALTER SCHEMA dbo TRANSFER Solarwinds.SURVEY
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_PARENT_CHILD
ALTER SCHEMA dbo TRANSFER Solarwinds.SURVEY_QUESTION
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_PERMISSION
ALTER SCHEMA dbo TRANSFER Solarwinds.SURVEY_QUESTION_RESPONSE
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_RESERVATION
ALTER SCHEMA dbo TRANSFER Solarwinds.SURVEY_RESPONSE
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_RESERVATION_ASSET
ALTER SCHEMA dbo TRANSFER Solarwinds.SYSTEM_INFO
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_STATUS
ALTER SCHEMA dbo TRANSFER Solarwinds.TASK
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.TASK_ELEMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.ASSET_TYPE_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.TASK_RUN
ALTER SCHEMA dbo TRANSFER Solarwinds.BILLING_LOGO
ALTER SCHEMA dbo TRANSFER Solarwinds.TAX_RATE
ALTER SCHEMA dbo TRANSFER Solarwinds.BILLING_RATE
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH
ALTER SCHEMA dbo TRANSFER Solarwinds.BILLING_TERM
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_FLAGGED_TICKETS
ALTER SCHEMA dbo TRANSFER Solarwinds.BUSINESS_ZONE
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_GROUP
ALTER SCHEMA dbo TRANSFER Solarwinds.CAB
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_GROUP_CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.CAB_CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_GROUP_LEVEL
ALTER SCHEMA dbo TRANSFER Solarwinds.CAB_CLIENT_DEPT
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_GROUP_LEVEL_TECH
ALTER SCHEMA dbo TRANSFER Solarwinds.CAB_CLIENT_LOC
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_GROUP_MESSAGE
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_PERMISSION
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_ADMIN_PERMISSION
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_NOTE
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_BULK_ACT_CO_LOC
ALTER SCHEMA dbo TRANSFER Solarwinds.TECH_PLUGIN_PREFERENCE
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_BULK_ACTION
ALTER SCHEMA dbo TRANSFER Solarwinds.TICKET_APPROVAL
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_BULK_ACTION_DEPT
ALTER SCHEMA dbo TRANSFER Solarwinds.TICKET_APPROVAL_STEP
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_BULK_ACTION_LOC
ALTER SCHEMA dbo TRANSFER Solarwinds.TICKET_ATTACHMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.TICKET_BULK_ACTION
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_GENERIC_ATTACHMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.TICKET_PERMISSION
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_LOCATION
ALTER SCHEMA dbo TRANSFER Solarwinds.TICKET_TAX_RATE
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_NOTE
ALTER SCHEMA dbo TRANSFER Solarwinds.TICKET_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_PERMISSION
ALTER SCHEMA dbo TRANSFER Solarwinds.VENDOR
ALTER SCHEMA dbo TRANSFER Solarwinds.CLIENT_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.TICKET_STATUS_TIME
ALTER SCHEMA dbo TRANSFER Solarwinds.CLOSED_MESSAGE
ALTER SCHEMA dbo TRANSFER Solarwinds.TKT_APP_STEP_CLIENT_VOTE
ALTER SCHEMA dbo TRANSFER Solarwinds.COL_SET_CUSTOM_FIELD_SEL
ALTER SCHEMA dbo TRANSFER Solarwinds.WARRANTY_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.COLUMN_SET
ALTER SCHEMA dbo TRANSFER Solarwinds.COMPANY
ALTER SCHEMA dbo TRANSFER Solarwinds.COMPANY_TECH
ALTER SCHEMA dbo TRANSFER Solarwinds.CONDITION
ALTER SCHEMA dbo TRANSFER Solarwinds.CONDITION_ARG
ALTER SCHEMA dbo TRANSFER Solarwinds.COOKIE_LOGIN
ALTER SCHEMA dbo TRANSFER Solarwinds.CUSTOM_FIELD_DEFINITION
ALTER SCHEMA dbo TRANSFER Solarwinds.CUSTOM_LOGO
ALTER SCHEMA dbo TRANSFER Solarwinds.DASHBOARD_WIDGET
ALTER SCHEMA dbo TRANSFER Solarwinds.DATABASE_INFO
ALTER SCHEMA dbo TRANSFER Solarwinds.DATE_FORMATTER
ALTER SCHEMA dbo TRANSFER Solarwinds.DELAYED_ACTION
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPARTMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPARTMENT_ADMIN_CONTACT
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPARTMENT_APPROVER_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPARTMENT_CUSTOM_FIELD
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPARTMENT_GROUP
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPARTMENT_GROUP_TECH
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPARTMENT_PROBLEM_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPARTMENT_TECH
ALTER SCHEMA dbo TRANSFER Solarwinds.DEPT_APPROV_TYPE_DEPT
ALTER SCHEMA dbo TRANSFER Solarwinds.DISCOVERY_ATTR_MAPPING
ALTER SCHEMA dbo TRANSFER Solarwinds.DISCOVERY_CONNECTION
ALTER SCHEMA dbo TRANSFER Solarwinds.EMAIL_ACCOUNT
ALTER SCHEMA dbo TRANSFER Solarwinds.EMAIL_DATA_OBJECT
ALTER SCHEMA dbo TRANSFER Solarwinds.EMAIL_HISTORY_ENTRY
ALTER SCHEMA dbo TRANSFER Solarwinds.EMAIL_TEMPLATE
ALTER SCHEMA dbo TRANSFER Solarwinds.EMAIL_LOGO
ALTER SCHEMA dbo TRANSFER Solarwinds.EMAIL_TEMPLATE_PREF
ALTER SCHEMA dbo TRANSFER Solarwinds.EO_PK_TABLE
ALTER SCHEMA dbo TRANSFER Solarwinds.FAQ_ATTACHMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.EMAIL_TEMPLATE_PROB_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.FAQ
ALTER SCHEMA dbo TRANSFER Solarwinds.FAQ_COMPANY
ALTER SCHEMA dbo TRANSFER Solarwinds.FAQ_LOCATION
ALTER SCHEMA dbo TRANSFER Solarwinds.FAQ_MODEL
ALTER SCHEMA dbo TRANSFER Solarwinds.FAQ_DEPARTMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.FAQ_TECH_GROUP
ALTER SCHEMA dbo TRANSFER Solarwinds.TIMEZONE_ADJUSTMENT_RULE
ALTER SCHEMA dbo TRANSFER Solarwinds.TIMEZONE
ALTER SCHEMA dbo TRANSFER Solarwinds.STYLESHEET
ALTER SCHEMA dbo TRANSFER Solarwinds.SERVICE
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_TRIGGERS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_SIMPROP_TRIGGERS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_SIMPLE_TRIGGERS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_SCHEDULER_STATE
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_PAUSED_TRIGGER_GRPS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_LOCKS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_JOB_DETAILS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_FIRED_TRIGGERS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_CRON_TRIGGERS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_CALENDARS
ALTER SCHEMA dbo TRANSFER Solarwinds.QRTZ_BLOB_TRIGGERS
ALTER SCHEMA dbo TRANSFER Solarwinds.ORION_SYNC_EVENTS
ALTER SCHEMA dbo TRANSFER Solarwinds.ORION_ALERT_SOURCES
ALTER SCHEMA dbo TRANSFER Solarwinds.ORION_ALERT_SEVERITY
ALTER SCHEMA dbo TRANSFER Solarwinds.ORION_ALERT_FILTERS
ALTER SCHEMA dbo TRANSFER Solarwinds.NODES
ALTER SCHEMA dbo TRANSFER Solarwinds.LOCATION_GROUP_MESSAGE
ALTER SCHEMA dbo TRANSFER Solarwinds.GENERIC_ATTACHMENT
ALTER SCHEMA dbo TRANSFER Solarwinds.FAQ_PROBLEM_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.DATABASE_VERSION
ALTER SCHEMA dbo TRANSFER Solarwinds.DASHBOARD
ALTER SCHEMA dbo TRANSFER Solarwinds.COMPUTER_IDENTITY
ALTER SCHEMA dbo TRANSFER Solarwinds.CLUSTER_NODE
ALTER SCHEMA dbo TRANSFER Solarwinds.CLUSTER_LICENSE
ALTER SCHEMA dbo TRANSFER Solarwinds.ATTACHMENT_DATA
ALTER SCHEMA dbo TRANSFER Solarwinds.API_KEY
ALTER SCHEMA dbo TRANSFER Solarwinds.SWIP_PRODUCT_INFO
ALTER SCHEMA dbo TRANSFER Solarwinds.CHECKLIST
ALTER SCHEMA dbo TRANSFER Solarwinds.CHECKLIST_ITEM
ALTER SCHEMA dbo TRANSFER Solarwinds.CHECKLIST_TEMPLATE
ALTER SCHEMA dbo TRANSFER Solarwinds.CHECKLIST_TEMPLATE_AUDIENCE
ALTER SCHEMA dbo TRANSFER Solarwinds.CHECKLIST_TEMPLATE_ITEM
ALTER SCHEMA dbo TRANSFER Solarwinds.CONDITION_ARG_DICTIONARY
ALTER SCHEMA dbo TRANSFER Solarwinds.CONDITION_ARG_NAME
ALTER SCHEMA dbo TRANSFER Solarwinds.CONDITION_ARG_TYPE
ALTER SCHEMA dbo TRANSFER Solarwinds.OBJECT_EDITING
ALTER SCHEMA dbo TRANSFER Solarwinds.PASSWORD_RESET
6. Go back to the Database Configuration Wizard screen, click Next and connect to your existing Database. Click Use Custom SQL database and enter the current database information.
7. When establishing a connection with the database, click Next and it will redirect now to the Web Help Desk login page.
Legal Disclaimer
Scripts are not supported under any SolarWinds support program or service. Scripts are provided AS IS without a 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.