When attempting up upgrade Sophos Enterprise Console the following error is seen:
SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.. To continue, correct the problem, and then run SQL Server Setup again.
Checking the SQL 'Errorlog' (usually located in C:\Program Files\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\Logs) shows:
2010-04-15 18:23:34.24 spid8s Error: 5118, Severity: 16, State: 1. 2010-04-15 18:23:34.24 spid8s The file "C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\MSDBData.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
First seen in Enterprise Console 4.0.0
This can be caused if the MSDBData.mdf database file has been compressed.
C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\
Compress contents to save disk space
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.