Documentation forWeb Help Desk

Prepare the WHD database

WHD supports the following databases:

  • Embedded PostgreSQL 
  • MySQL
  • Microsoft SQL Server Standard or Enterprise Edition with server collation set to case insensitive.

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

To prevent database errors in the application, do not modify the default schemas.

If you choose embedded PostgreSQL as your primary database, WHD installs the database on the WHD server during the installation. You can create a backup schedule or initiate a manual backup in the Database Connection page at Setup > General > Database.

If you choose non-embedded, non-default MySQL as your primary database, install the database engine and management tools on a separate server prior to installing WHD. See the MySQL website at https://www.mysql.com for the installation instructions.

Install 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. After you install MySQL, prepare the MySQL time zone tables.

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

Install SQL Server 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 WHD to use a new SQL Server database instance on an existing server running SQL Server.

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

Prepare the MySQL time zone tables

For additional information on how to populate the time zone data, see MySQL Server Time Zone Support and Time Zone Description Tables located on the MySQL Developer Zone website at https://dev.mysql.com.

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:

  • time_zone
  • time_zone_name
  • time_zone_transition
  • time_zone_transition_type

These tables are created when you install MySQL in your deployment, but are not populated by default with data. WHD requires this data because the Due Date and First Call Resolution qualifier logic is implemented from within the database. If the database is missing time zone data, these qualifiers do not work properly.

When you install your MySQL database, be sure to manually populate these system tables with time zone data. See the MySQL website at www.mysql.com and follow the instructions for MySQL Server time zone support.

You can check the system tables by executing the following query:

SELECT * FROM mysql.time_zone

If the query does not create new table rows, the tables are not populated with data.

Enable TCP/IP in SQL Server

Configure the following settings in the SQL Server Configuration Manager.

Setting Value
TCP/IP Protocol Enabled in SQL Server Network Configuration > Protocols for SQL 20xx
IP Address

127.0.0.1 (if installed on the WHD server)

Server IP address (if installed on a separate server)

TCP Port 1433
IPAll
TCP Dynamic Ports Blank
TCP Port 1433

Create and configure your SQL Server database

  1. In your SQL Server database, verify that the server collation is set to case insensitive. This ensures that WHD initializes the database correctly and prevents database errors when you configure the application.

    See the SQL Server documentation on the Microsoft Docs website for details about server collation.

    If the server collation is set to case insensitive, go to step 2.

    If the server collation is set to case sensitive, create a new database.

    1. On the server hosting SQL Server, open SQL Server Management Studio.
    2. In the navigation menu, locate and maximize the targeted SQL Server instance.
    3. Right-click Databases and select New Database.
    4. In the New Database window under Select a page, click Options.
    5. Click the Collation drop-down menu and select a case insensitive option.

      SolarWinds recommends the following option:

      Latin1_General_CI_AS

    6. Click OK.
  2. Configure the database settings.
  3. Install WHD on the host server.
  4. Run the Getting Started Wizard.

    If you did not create a new database in step 1, create a new database and login credentials using the WHD Getting Started Wizard.

    If you created a new database in step 1, add the database name and login credentials in the WHD Getting Started Wizard.

  5. Open WHD and link the application to the new SQL Server database.
  6. (Optional) Enable SSL encryption.

    See Configure Microsoft SQL Server in the WHD Administrator Guide for details.

Configure the database settings

Configure the following settings in the SQL Server Management Studio for SQL Server to create and configure SQL Server to the WHD database instance.

Setting Value
SQL Server Authentication Enabled
Login Name whd
SQL Server Authentication: 
Enforce password expiration
Disabled
SQL Server Authentication: 
User must change password
at next login
Disabled
Database name whd
Database owner whd