Error installing the Kaspersky Security Center database on a compressed drive
Latest update: June 28, 2022
ID: 15485
This article concerns:
- Kaspersky Security Center 13.2 (version 13.2.0.1511)
- Kaspersky Security Center 13.1 (version 13.1.0.8324)
- Kaspersky Security Center 13 (version 13.0.0.11247)
- Kaspersky Security Center 12 (version 12.0.0.7734)
- Kaspersky Security Center 11 (version 11.0.0.1131b)
Issue
When installing the Administration Server, an error may occur at the database creation step which does not allow to complete the installation.
Error example:
"Error has occurred while installing: Generic db error: "5118 '
{42000}
'The file "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\KAV.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.' LastStatement='IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = 'KAV') CREATE DATABASE [KAV];'"."
{42000}
'The file "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\KAV.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.' LastStatement='IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = 'KAV') CREATE DATABASE [KAV];'"."
Solution
- Open the properties of the folder with the files of the corresponding Database Management System (DBMS). For example: C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\
- Open the General tab and click Advanced in the Attributes section.
- Clear the checkbox Compress contents to save disk space.
- Click OK → OK.
- Restart the SQL Server service or the computer on which the error occurs.
- Run the installation of the Administration Server once again.
