Documentation
|
Support
Administering Forcepoint Databases
> Microsoft SQL Server deployment options
Microsoft SQL Server deployment options
Administering Forcepoint Databases | Web, Data, and Email Solutions | 8-June-2020
Applies to:
Forcepoint Web Security and Forcepoint URL Filtering, v8.5.x
Forcepoint DLP, v8.5.1, v8.6.x, v8.7.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?
.
SQL Server Express on the management server
Important
Forcepoint has removed the ability to install SQL Express as an option for new deployments of Forcepoint Security Manager. This change was introduced via a revised version of the Forcepoint Security Installer introduced in July 2019.
The change was required to reduce the risk of deploying SQL 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.
For smaller deployments (up to 500 users), the reporting databases can be installed on the Forcepoint management server. To do this, select the
Install SQL Server Express on this machine
option, if available, during a Custom installation.
When included, use only the version of SQL Server Express included in the Forcepoint Security Installer. If not included, download and install the supported version of SQL Server Express from Microsoft.
SQL Server Express can run with Forcepoint software on the Windows platforms noted in the
Certified Product Matrix
.
Administering Forcepoint Databases
> Microsoft SQL Server deployment options
Copyright 2020 Forcepoint. All rights reserved.