Installing SQL Server Express (without Forcepoint Infrastructure)

Before you begin

Applies to:
  • Forcepoint Web Security and Forcepoint URL Filtering, v8.5.x
  • Forcepoint DLP, v8.5.x, v8.6.x, v8.7.x, v8.8.x, v8.9.x, v9.0, v10.x
  • Forcepoint Email Security, v8.5.x
  • Forcepoint appliances, v8.5.x
Important: Forcepoint has removed the ability to install SQL Server Express as an option for new deployments of Forcepoint Security Manager. This change was made via a revised version of Forcepoint Security Installer introduced in July 2019, which can be found on the Downloads page. The change was required to reduce the risk of deploying SQL Server Express without the latest security updates. Forcepoint Security Manager still supports and will work with the latest version of SQL Server Express. You may use SQL Server Express for small deployments, but it must be installed independently.

During installation, you can choose to install SQL Server Express. This section provides instructions for installing SQL Server Express without installing Forcepoint Infrastructure. Typically, this is done to install SQL Server Express on a machine that is not a Forcepoint management server.

Steps

  1. If you will use SQL Server Express to store and maintain reporting data, log in to the machine as domain user. Do this prior to starting the Forcepoint Security Installer.
  2. It is a best practice to install the Windows prerequisites for installing SQL Server Express beforehand:
    • .NET Framework 3.5 SP1.NET 4.5 is also required by the installer so make sure this is installed as well.
    • Powershell 1.0
    • Windows Installer 4.5
    Note: The installer will automatically install these if not found on the machine.

    See SQL Server Express section in Preparing for installation.

  3. It is assumed you have already launched the Forcepoint Security Installer and chosen the Custom installation type. If not, see Starting a custom installation (Windows).
  4. On the Custom Installation dashboard, click the Install link for SQL Server Express.
  5. On the Welcome screen, click Start to begin the installation wizard.
  6. On the Configuration screen, select options as described below and then click Next.
    • Use the Browse button to specify a different folder if you do not want to install to the default location shown.
    • If you want to create a named instance, instead of using the default SQL Server instance, select Named instance and then enter an instance name. Note the following about instance names:
      • Not case sensitive
      • 16 characters or less
      • Only letters, numbers, dollar sign ($), or underscore (_) are allowed
      • First character must be a letter
      • Cannot contain the term Default or other reserved keyword (see Microsoft documentation for more information about reserved keywords)
    • Select an authentication mode:
      • Windows Authentication mode: select this to use Windows authentication, i.e., trusted connection, to authenticate users.
      • Mixed Mode (SQL Server authentication and Windows authentication): select this to use SQL Server authentication. Enter a password (and re-enter to confirm) for the built-in SA user.
    Depending on your selections, the Pre-Installation Summary screen, will show different information than shown in the above illustration.
    CAUTION:
    Depending on whether certain Windows prerequisites are installed, your machine may be automatically restarted up to two times during the installation process. Restarts are not required if the prerequisites are already installed.
  7. In the Pre-Installation Summary screen, click Next to begin installation.
    The Setup Support Files screen appears and then an Installation Progress screen appears. Wait for these screens to complete automatically. It is not necessary to click or select anything in these screens.

    Note that it may take approximately 10–15 minutes for the SQL Server Express installation to complete.

  8. Next, the Installation screen appears. Wait until all files have been installed.
  9. On the Summary screen, click Finish.