0
(0)

Issue

ESET business product in Limited Support status

This article applies to an ESET product version that is currently in Limited Support status and is scheduled to reach End of Life status soon.

For a complete list of supported products and support level definitions, review the ESET End of Life Policy for business products.

Upgrade ESET business products.

  • You do not have an appropriate database for your ESMC Server installation
  • You want to set up 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 ESMC Server to connect the database. You should create a dedicated database user as well as a dedicated database.

Solution

Create a database and user for ESET Security Management Center 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 (ESMC Server, MDM Server) needs its own database and database user.

Prerequisites:

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

Create a database:

  1. Open the MS SQL Server Management Studio and login with your Administrator account.
  2. In the Object Explorer right-click Databases and select New Database… from the context menu.
  3. Type the database name in the Database name text box. You will need this name during the installation of ESET Security Management Center. For example, you can use the default ESET Security Management Center database name era_db.
  4. Click OK and continue to the next section to assign a new user to your database.

Create and assign a new user:

  1. Open MS SQL Server Management Studio and log in with your Administrator account.
  2. In Object Explorer, right-click Security → New → Login…
  3. Type the user name of your new user in the Login name field. For example, you can use the default ESET Security Management Center database user name era_user.
  4. Select the SQL Server authentication option.
  5. Set your new password and type it in the Password and Confirm password fields. You can also set other properties here, but it is not required.
  6. Select User Mapping and then click Map next to the database you created. Your user name should appear in the column User next to the database you selected.
  7. Select the field db_owner in the Database role membership window. Click OK to save your changes.

Figure 1-1

Keep your credentials safe!

You will need your database name and credentials (username and password) during ESET Security Management Center installation.


Create a database and user for ESET Security Management Center in MySQL

Prerequisites:

  • You must have administrative access to the OS.
  • MySQL must be installed.
  • You must have an administrator account in MySQL.
  • In this article, we will use HeidiSQL as our administration tool. You can use a different tool or the command line to achieve the same results, however some steps may differ according to the tool you use.

Create a database:

  1. Open your MySQL administration tool and log in to the local database using the root account and password. Set the Hostname as 127.0.0.1.
  2. Click Open to open your session. Right-click root and select Create new → Database from the context menu.
  3. Enter a name for your database. For example, you can use the default ESET Security Management Center database name era_db.

Create and assign new user:

  1. Open your MySQL administration tool and log in to the local database using a root account.
  2. Set the Hostname to 127.0.0.1.
  3. Click Tools → User management and then click Add.
  4. Type name of new user in to the Username field. We recommend that you use a self-explanatory username like era_db_user. Set a secure password in the Password and Repeat password text boxes.
  5. Set the From host value to Access form everywhere.
  6. Click Add object, add the database you created earlier and then click OK.
  7. Under Allow access to, select the 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. Click Save to confirm the user settings and then click Clone. You will now have two users with same name. For the newly copied user, change the value of From host to Access from server location only and then click Save.

Figure 2-1

Keep your credentials safe

You will need your database name and credentials (username and password) during ESET Security Management Center installation.

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

(Visited 67 times, 1 visits today)