The following tables provide information about how selecting a database management system (DBMS) affects the properties of accounts chosen for work with the DBMS.
Local DBMS is a DBMS installed on the same device as Administration Server. Remote DBMS is a DBMS installed on a different device.
Please grant all rights required for the Administration Server account before you start the Administration Server service.
SQL Server with Windows authentication and with SQL Server authentication
DBMS: SQL Server (including Express Edition) with Windows authentication
DBMS location |
Local |
Local |
Remote |
Remote |
Who creates the KAV database |
The installer (automatically) |
Administrator (manually) |
The installer (automatically) |
Administrator (manually) |
Account under which the installer is running |
Local or domain |
Local or domain |
Domain |
Domain |
Rights of the account under which the installer is running |
|
|
|
|
Administration Server account |
|
|
Domain |
Domain |
Rights of the Administration Server service account |
|
|
|
|
DBMS: SQL Server (including Express Edition) with SQL Server authentication
DBMS location |
Local |
Remote |
Who creates the KAV database |
Administrator (manually) or the installer (automatically) |
Administrator (manually) or the installer (automatically) |
Account under which the installer is running |
Local |
Domain |
Rights of the account under which the installer is running |
|
|
Administration Server service account |
Local or domain |
Domain |
Rights of the Administration Server service account |
|
|
Additional information |
The administrator explicitly specifies in the installer a SQL Server internal account that requires the sysadmin role |
The administrator explicitly specifies in the installer a SQL Server internal account that requires the sysadmin role |
MySQL
DBMS: MySQL
DBMS location |
Local or remote |
Local or remote |
Who creates the KAV database |
The installer (automatically) |
Administrator (manually) |
Account under which the installer is running |
Local or domain |
Local or domain |
Rights of the account under which the installer is running |
|
|
Administration Server service account |
Local or domain |
Local or domain |
Rights of the Administration Server service account |
|
|
Additional information |
The administrator explicitly specifies in the installer a SQL Server internal account that requires root access. |
The administrator explicitly specifies in the installer a MySQL internal account that requires GRANT ALL for the KAV database and SELECT, SHOW VIEW, PROCESS for the system tables. |