Specify the database server and connector you want to use when installing the ESET PROTECT Server. You can use an existing database server running in your environment; however, it must meet the requirements below.
|
|
Note The ESET PROTECT 8.1 All-in-one installer installs Microsoft SQL Server Express 2019 by default. If you use an older Windows edition (Server 2012 or SBS 2011), Microsoft SQL Server Express 2014 will be installed by default. The installer automatically generates a random password for database authentication (stored in %PROGRAMDATA%\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\startupconfiguration.ini). |
Supported database servers and database connectors
ESET PROTECT supports two types of database servers: Microsoft SQL Server and MySQL.
|
|
Warning ESET PROTECT does not support MariaDB. MariaDB is a default database in most current Linux environments and gets installed when you select to install MySQL. |
|
Supported database server |
Supported database versions |
Supported database connectors |
|
Microsoft SQL Server |
•Express and non-Express editions
•2012, 2014, 2016, 2017, 2019
|
•SQL Server
•SQL Server Native Client 10.0 •ODBC Driver for SQL Server 11, 13, 17 |
|
MySQL |
•5.6*
•5.7 •8.0 |
MySQL ODBC driver versions: •5.1, 5.2 •5.3.0–5.3.10 •8.0.16, 8.0.17 |
* MySQL 5.6 reached the End of Life in February 2021. We recommend that you upgrade your MySQL database server to version 5.7 and later.
|
|
Warning The following MySQL ODBC driver versions are not supported: •5.3.11 and later 5.3.x •8.0.0–8.0.15 •8.0.18 and later |
Database server hardware requirements
See the hardware and sizing instructions.
Performance recommendations
We recommend using the latest supported Microsoft SQL Server as your ESET PROTECT database for the best performance. While ESET PROTECT is compatible with MySQL, using MySQL can negatively impact system performance when working with large amounts of data, including dashboards, detections, and clients. The same hardware with Microsoft SQL Server can handle a significantly higher number of clients than with MySQL.
You can decide whether to install an SQL database server on:
•The same machine as the ESET PROTECT Server.
•The same machine, but on a separate disk.
•A dedicated server for the installation of an SQL database server.
We recommend that you use a dedicated machine(s) with reserved resources if you wish to manage more than 10,000 clients.
|
Database |
SMB customer |
Enterprise customer |
Clients limit |
Windows |
Linux |
|---|---|---|---|---|---|
|
MS SQL Express |
✔ |
(optional) |
5,000 |
✔ |
|
|
MS SQL Server |
✔ |
✔ |
None |
✔ |
|
|
MySQL |
✔ |
✔ |
10,000 |
✔ |
✔ |
Additional information
•The ESET PROTECT 8.1 All-in-one installer installs Microsoft SQL Server Express 2019 by default. If you use an older Windows edition (Server 2012 or SBS 2011), Microsoft SQL Server Express 2014 will be installed by default. The installer automatically generates a random password for database authentication (stored in %PROGRAMDATA%\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\startupconfiguration.ini).
•Microsoft SQL Server Express has a 10 GB size limit for each relational database. We do not recommend using Microsoft SQL Server Express in enterprise environments or large networks.
•Do not install SQL Server on a Domain Controller (for example, Windows SBS / Essentials). We recommend that you install ESET PROTECT on a different server or do not select the SQL Server Express component during installation (this requires you to use your existing SQL or MySQL Server to run the ESET PROTECT database).
•If you intend to use a dedicated database user account that will only have access to the ESET PROTECT database, you must create a user account with specific privileges before installation. For more information, see the dedicated database user account. Additionally, you will need to create an empty database that will be used by ESET PROTECT.
•See the instructions to install and configure MySQL for Windows and MySQL for Linux to work properly with ESET PROTECT.
•MS SQL Server on Linux is not supported. However, you can connect the ESET PROTECT Server on Linux to MS SQL Server on Windows.
•If you install the ESET PROTECT Server and MS SQL Server on separate computers, you can enable encrypted connection to the database.
•ESET PROTECT Server does not use an integrated backup. We strongly recommend that you back up your database server to prevent data loss.
•The cluster setup of the database on Windows environments is supported only for the MS SQL Server, not for MySQL.
Source : Official ESET Brand
Editor by : BEST Antivirus KBS Team