Database

ESET Security Management Center supports two types of database servers:

Microsoft SQL Server (including Express and non-Express editions) 2008, 2008 R2, 2012, 2014, 2016, 2017

MySQL (5.5+ is supported, we strongly recommend you to use at least version 5.6)

validation-status-icon-error WARNING

MySQL database is supported up to version 5.7 and ODBC driver up to version 5.3.10. Upgrading to a higher version (5.3.11 or 8.x) of MySQL and ODBC driver is not recommended.

The ESMC Virtual Appliance is running ODBC 8.0.11-e17. From the 8.x versions, only this version is proven to be compatible with the ESMC. Major Linux distributions do not provide this version in their repository.

Specify the database server you want to use when installing ESMC Server. Microsoft SQL Server Express is installed by default and is a part of the All-in-one installer. You can use an existing Microsoft SQL Server running in your environment; however, it must meet the minimum requirements.

Database server hardware requirements

Memory

2 GB RAM

Hard Drive

At least 10 GB of free space

Processor Speed

x86 Processor: 1.3 GHz
x64 Processor: 1.6 GHz
Note: A 2.0 GHz or faster processor is recommended for optimum performance.

Processor Type

x86 Processor: Pentium IV-compatible processor or faster
x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

Additional information

Microsoft SQL Server Express has a 10 GB size limit of each relational database. We do not recommend the use of Microsoft SQL Server Express in Enterprise environments or large networks.

We recommend that you do not install SQL Server on a Domain Controller (for example, if you are using Windows SBS / Essentials). We recommend that you install ESET Security Management Center 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 ESMC database).

If you intend to use a dedicated database user account that will only have access to the ESMC database, you must create a user account with specific privileges before installation. For more information, see Dedicated database user account. Additionally, you will need to create an empty database that will be used by ESET Security Management Center.

See the instructions to install and configure MySQL for Windows and MySQL for Linux to work properly with ESET Security Management Center. Note that MariaDB is not supported by ESET Security Management Center.

MS SQL Server on Linux is not supported. However, you can connect ESMC Server on Linux to MS SQL Server on Windows.

If you install ESMC Server and MS SQL Server on separate computers, you can enable an encrypted connection to the database.

ESMC Server does not use an integrated backup. We strongly recommend that you back up your database server to prevent data loss.

Cluster setup of the database on Windows environments is supported only for MS SQL Server, not for MySQL.