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
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.