ESET Online Help

Search English
Select the category
Select the topic

Dedicated database user account

If you do not want to use an SA account (Microsoft SQL) or root account (MySQL), you can create a dedicated database user account. This dedicated user account will be used to access the ESET PROTECT database only. We recommend that you create a dedicated database user account within your database server before starting ESET PROTECT On-Prem installation. Also, you will need to create an empty database that will be accessed by ESET PROTECT On-Prem using this dedicated user account.

There is a minimum set of privileges that must to be granted to a dedicated database user account:

MySQL user privileges: ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EXECUTE, INDEX, INSERT, LOCK TABLES, SELECT, UPDATE, TRIGGER. For more information about MySQL privileges, see http://dev.mysql.com/doc/refman/8.0/en/grant.html.

Microsoft SQL Server database-level roles: An ESET PROTECT database user must be a member of the db_owner database role. For more information about Microsoft SQL Server database-level roles, see https://msdn.microsoft.com/en-us/library/ms189121%28v=sql.100%29.aspx


note

A dedicated Microsoft SQL database user with Windows authentication

You can set up a Windows user as a dedicated Microsoft SQL database user with Windows authentication:

During the database installation—Select Mixed Mode (SQL Server authentication and Windows authentication)

When the database is installed—Use the SQL Server Management Studio > in the Object Explorer, expand Security > right-click Logins > New Login > type the Login name in the format HOSTNAME\username > select Windows Authentication > click Server Roles > select public and sysadmin.

If you select Log in as current Windows user during the ESET PROTECT Server installation (all-in-one or standalone installation), the username and password are not visible in the startupconfiguration.ini file. You see Trusted_Connection=yes instead. See also Connect ESET PROTECT Server to a database.

You can find detailed guide how to set up your database and user account for both Microsoft SQL and MySQL in our Knowledgebase article.