Microsoft SQL Server deployment options

Note:

Applies to:

  • Forcepoint Web Security and Forcepoint URL Filtering, v8.5.x
  • Forcepoint DLP, v8.5.1, 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

In deployments of over 500 users, the best practice is to host the reporting databases on a Standard or Enterprise installation of Microsoft SQL Server. SQL Server typically resides on a dedicated machine. It may host databases for third-party applications, in addition to the Forcepoint databases.

If SQL Server resides on a dedicated machine and there are multiple SQL instances installed, SQL Server Browser must be running.

During Forcepoint software installation, the setup program prompts for the IP address or hostname of the SQL Server machine. It is also possible to specify:

  • An instance name
  • The port to use for SQL Server communication
  • Whether or not to encrypt communication with SQL Server

Find the supported versions of Microsoft SQL Server for your product by selecting the appropriate link in the Certified Product Matrix.

Clustering is supported for all supported versions of SQL Server noted in the Certified Product Matrix linked above (Forcepoint Email Security and Forcepoint Web Security only).

See Can reporting databases be hosted in a SQL Server cluster?.