Connect ESMC Server or MDM to a database

Follow the steps below on the machine where ESMC Server or ESMC MDM is installed to connect it to a database.

1.Stop the ESMC Server/MDM service.

2.Find startupconfiguration.ini

oFor Windows Vista and later:
Server:

%PROGRAMDATA%\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\startupconfiguration.ini
 MDMCore:
%PROGRAMDATA%\ESET\RemoteAdministrator\MDMCore\EraServerApplicationData\Configuration\startupconfiguration.ini

oFor earlier Windows versions:
Server:

%ALLUSERSPROFILE %\Application Data\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\startupconfiguration.ini
 MDMCore:
%ALLUSERSPROFILE %\Application Data\ESET\RemoteAdministrator\MDMCore\EraServerApplicationData\Configuration\startupconfiguration.ini

oFor Linux:
Server:

/etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini
 MDMCore:
/etc/opt/eset/RemoteAdministrator/MDMCore/startupconfiguration.ini

3.Change the database connection string in ESMC Server/MDM startupconfiguration.ini

oSet the address and port of the new database server.

oSet new ESMC user name and password in the connection string.

The final result should look like:
 

note

Note

In the configuration below, please always replace:

TARGETHOST with the address of the target database server

TARGETERADBNAME with the name of the target ESMC database (after migration)

TARGETERALOGIN with the login name for the new ESMC database user on the target database server

TARGETERAPASSWD with the password of the new ESMC database user on the target database server

oMS SQL:

DatabaseType=MSSQLOdbc

DatabaseConnectionString=Driver=SQL Server;Server=TARGETHOST,1433;Uid=TARGETERALOGIN;Pwd={TARGETERAPASSWD};CharSet=utf8;Database=TARGETERADBNAME;

oMySQL:

DatabaseType=MySqlOdbc
DatabaseConnectionString=Driver=MySQL ODBC 5.3 Unicode Driver;Server=TARGETHOST;Port=3306;User=TARGETERALOGIN;
Password={TARGETERAPASSWD};CharSet=utf8;Database=TARGETERADBNAME;

 

4.Start the ESMC Server or ESMC MDM and verify that the service is running correctly.