Database Server Backup/Upgrade and ESET PROTECT Database Migration
ESET PROTECT uses a database to store client data. The following sections detail the backup, upgrade and migration 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.0 All-in-one installer installs Microsoft SQL Server Express 2019 by default.
oIf you use an older 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).
|
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 Enterprise Inspector. |
• If you have an older unsupported database installed (MySQL 5.5 or MS SQL 2008/2012), upgrade your database to a compatible database version before upgrading the ESET PROTECT Server.
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.
|
•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). |
ESET PROTECT Database migration
These instructions apply to ESET PROTECT database migration between different SQL Server instances (this also applies when migrating to a different SQL Server version or when migrating to a SQL Server hosted on a different machine):