[KB6212] Create databases and database user accounts for ESET Remote Administrator (6.x)

Issue

  • You do not have anappropriate database for your ERA Server or ERA Proxy installation
  • You want to setup a dedicated database user for MS SQL or MySQL

Details

The creation of an Administrator or root account is required as part of MS SQL or MySQL installation.

It is not recommended to use sa / root (database administrator) account for ERA Server (nor Proxy) to connect the database. You should create a dedicated database useras well as adedicated database.

Solution

End of support for version 6.4 and 6.5 of ESET Remote Administrator / MDM

ESET Remote Administrator version 6.5 is currently in Limited Support status and will soon be in Basic Support status. It is expected to reach End of Life status in December 2020.

ESET Remote Administrator version 6.4 is currently in basic support status and is expected to reach End of Life status in December 2019.

The MDM functionality in ESET Remote Administrator version 6 is in Basic Support status as of April 11, 2019. After this date, MDM version 6 will no longer be available for download.

Create a database and user for ESET Remote Administrator in MS SQL

A dedicated database must have at least one dedicated user

Do not use the same database user for more components or purposes. Each component (ERA Server, ERA Proxy) needs its own database and database user.

Prerequisites:

  • You must have administrative access to the OS.
  • MicrosoftSQL Server Management Studiomust be installed(in this exampleSQL Server 2016 is used).
  • You must have an administrative account inMicrosoft SQL Server Management Studio.

Create database:

  1. Open the MS SQL Server Management Studio and login with your Administrator account.
  2. In the Object Explorer right-clickDatabases and selectNew Database...fromthe contextmenu.
  3. Enter a name for your database. We recommend that you usea name that suits the database's purpose, like era_db or era_proxy.

    Type the database name in the Database nametext box. You will need this name during the installation of ESET Remote Administrator.
  4. ClickOKand continue to the next section to assign a new user to your database.

Create and assign new user:

  1. Open MS SQL Server Management Studio and log in with your Administrator account.
  2. In Object Explorer,right-clickSecurity NewLogin...
  3. Typethe user name of your new user inthe Login namefield.
  4. Select theSQL Server authenticationoption.
  5. Set your new password and type it in the Password and Confirm passwordfields. You can also set other propertieshere, but it is not required.
  6. Select User Mappingand then clickMapnext to the database you created. Youruser name should appear in the column Usernext to thedatabase you selected.
  7. Select the field db_owner in the Database role membershipwindow. ClickOKto save your changes.

How to set the database user in the MS SQL Server Management

Figure 1-1

Keep your credentials safe!

You will need your database name and credentials (username and password) during ESET Remote Administrator installation.


How to create a database and user for ESET Remote Administrator in MySQL

Prerequisites:

  • You must have administrative access to the OS.
  • MySQL must be installed.
  • You must have an administrator account in MySQL.
  • Inthis artice, we will useHeidiSQLas ouradministration tool. You can use a differenttool or the command line to acheive thesame results, however some steps may differ according to the tool you use.

Create database:

  1. Open your MySQL administration tool and log in to the local database using the root account and password. Set the Hostnameas127.0.0.1 .
  2. ClickOpen to open your session.Right-click root and selectCreate newDatabase from the context menu.
  3. Enter aname for your database.We recommend that you usea name that suits the database's purpose, likeera_dborera_proxy.

Create and assign new user:

  1. Open your MySQL administration tool and log in to the local database using a root account.
  2. Set theHostnameto 127.0.0.1.
  3. Click ToolsUser managementand then clickAdd.
  4. Type name of new user in to theUsernamefield. Werecommend that youuse a self-explanatory username likeera_db_user.Set a secure password in the Password and Repeat password text boxes.
  5. Set theFrom hostvalue to Access form everywhere.
  6. ClickAdd object,add the database you created earlier and then clickOK.
  7. UnderAllow access to, selectthe new database and mark the following properties:
    • ALTER
    • ALTER ROUTINE
    • CREATE, CREATE ROUTINE
    • CREATE TEMPORARY TABLES
    • CREATE VIEW
    • DELETE, DROP
    • EXECUTE
    • INDEX
    • INSERT
    • LOCK TABLES
    • SELECT
    • UPDATE
    • TRIGGER.
  8. ClickSave to confirm the user settings and then click Clone.You will now have twousers with same name. For the newly copied user,change the value ofFrom hosttoAccess from server location onlyand then clickSave.

Figure 1-2

Keep your credentials safe

You will need your database name and credentials (username and password) during ESET Remote Administrator installation.