When selecting the database management system (DBMS) to be used by an Administration Server, you must take into account the number of devices covered by the Administration Server.
The following table lists the valid DBMS options, as well as the recommendations and restrictions on their use.
Recommendations and restrictions on DBMS
DBMS |
Recommendations and restrictions |
|---|---|
SQL Server Express Edition 2016 or later |
Use this DBMS if you intend to run a single Administration Server for less than 10,000 devices. It is recommended to disable the Software inventory task and disable (in the Kaspersky Endpoint Security policy settings) notifications of Administration Server on started applications. You can limit the maximum number of events in the event repository to prevent database overflow. Refer to the following topic for details: Calculation of database space. Concurrent use of the SQL Server Express Edition DBMS by Administration Server and another application is strictly forbidden. The Microsoft SQL Express database is not supported for the Perform Windows Update synchronization task. |
Local SQL Server edition, other than Express, 2016 or later |
No limitations. |
Remote SQL Server edition, other than Express, 2016 or later |
Only valid if both devices are in the same Windows® domain; if the domains differ, a two-way trust relationship must be established between them. |
Local or remote MySQL 5.5, 5.6, or 5.7 (MySQL versions 5.5.1, 5.5.2, 5.5.3, 5.5.4, and 5.5.5 are no longer supported) |
Use this DBMS if you intend to run a single Administration Server for less than 10,000 devices. It is recommended to disable the Software inventory task and disable (in the Kaspersky Endpoint Security policy settings) notifications of Administration Server on started applications. Refer to the following topic for details: Calculation of database space. |
Local or remote MySQL 8.0.20 or later |
Use this DBMS if you intend to run a single Administration Server for less than 50,000 devices. It is recommended to disable the Software inventory task and disable (in the Kaspersky Endpoint Security policy settings) notifications of Administration Server on started applications. Refer to the following topic for details: Calculation of database space. |
Local or remote MariaDB (see supported versions) |
Use this DBMS if you intend to run a single Administration Server for less than 20,000 devices. It is recommended to disable the Software inventory task and disable (in the Kaspersky Endpoint Security policy settings) notifications of Administration Server on started applications. Refer to the following topic for details: Calculation of database space. |
PostgreSQL, Postgres Pro (see supported versions) |
Use one of these DBMS if you intend to run a single Administration Server for less than 50,000 devices. It is recommended to disable the Software inventory task and disable (in the Kaspersky Endpoint Security policy settings) notifications of Administration Server on started applications. Refer to the following topic for details: Calculation of database space. |
If you use a PostgreSQL, MariaDB or MySQL DBMS, the Events tab may display an incomplete list of events for the selected client device. This occurs when the DBMS stores a very large amount of events. You can increase the number of displayed events by doing either of the following:
To see a full list of events logged on the Administration Server for the device, use Reports.
If you are using SQL Server 2019 as a DBMS and you do not have cumulative patch CU12 or later, you have to perform the following after installing Kaspersky Security Center:
USE KAV
GO
ALTER DATABASE SCOPED CONFIGURATION SET TSQL_SCALAR_UDF_INLINING = OFF
GO
Otherwise, using SQL Server 2019 may result in errors, such as "There is insufficient system memory in resource pool 'internal' to run this query."