Database Server Backup/Upgrade

ESET PROTECT uses a database to store client data. The following sections detail the backup and upgrade of the ESET PROTECT Server (or ESMC Server) database or MDM database:

If you do not have a database configured for use with ESET PROTECT Server, Microsoft SQL Server Express is included with the installer. The ESET PROTECT 9.1 All-in-one installer installs Microsoft SQL Server Express 2019 by default.

oIf you use an earlier Windows edition (Server 2012 or SBS 2011), Microsoft SQL Server Express 2014 will be installed by default.

oThe installer automatically generates a random password for database authentication (stored in %PROGRAMDATA%\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\startupconfiguration.ini).


warning

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.

If you want to use ESET PROTECT with ESET Inspect.

If you have an earlier unsupported database installed (MySQL 5.5 or Microsoft SQL 2008/2012), upgrade your database to a compatible database version before upgrading the ESET PROTECT Server.

 

See also ESET PROTECT database migration.

The following requirements for Microsoft SQL Server must be met:

Install a supported version of Microsoft SQL Server. Choose Mixed mode authentication during installation.

If you have Microsoft SQL Server already installed, set authentication to Mixed mode (SQL Server authentication and Windows authentication). To do so, follow the instructions in this Knowledgebase article. If you want to use Windows Authentication to log in to Microsoft SQL Server, follow the steps in this Knowledgebase article.

Allow TCP/IP connections to the SQL Server. To do so, follow the steps in this Knowledgebase article from part II. Allow TCP/IP connections to the SQL database.


note

To configure, manage and administer Microsoft SQL Server (databases and users), download SQL Server Management Studio (SSMS).

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).