Error installing the Kaspersky Security Center database on a compressed drive
Latest update: May 08, 2020
ID: 15485
This article concerns:
- Kaspersky Security Center 12 (version 12.0.0.7734)
- Kaspersky Security Center 11 (version 11.0.0.1131)
- Kaspersky Security Center 10 Service Pack 3 (version 10.5.1781.0)
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.