Prepare the Web Help Desk database

SolarWinds Web Help Desk supports the following databases:

  • Embedded PostgreSQL 
  • MySQL™
  • Microsoft® SQL Server Standard or Enterprise Edition

If your Web Help Desk deployment requires database management features such as failover clusters, do not use the embedded PostgreSQL database included with Web Help Desk. Failover clusters are not available with the embedded PostgreSQL database.

If you choose embedded PostgreSQL as your primary database, Web Help Desk installs the database on the Web Help Desk server during the installation. No additional configuration is required.

If you choose non-embedded, non-default Microsoft SQL Server or MySQL as your primary database, install the database engine and management tools on a separate server prior to installing Web Help Desk. See the Microsoft TechNet or MySQL website for installation instructions.

Install SQL Server or MySQL on a dedicated drive with at least 20 GB of space to accommodate the database engine, management tools, help desk tickets, and ticket file attachments. You can also configure Web Help Desk to use a new SQL Server database instance on an existing server running SQL Server.

After you install the MySQL software, prepare the MySQL time zone tables.

After you install the SQL Server software, enable TCP/IP on the SQL server and create and configure your SQL Server database.

Prepare the MySQL time zone tables

If you choose non-embedded, non-default MySQL as your primary database, install the database and manually populate your time zone system tables.

You can search for tickets using two new qualifiers: Due Date and First Call Resolution. These qualifiers rely on data located in four MySQL system tables: