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

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