Forefront Endpoint Protection 2010 Report. Error: Subreport Could Not Be Shown

When running the Antimalware Activity Report, the Malware Activity section of the report failed to run and showed the error “Subreport could not be shown”.

The environment is System Center Configuration Manager (SCCM) 2007 R2, Forefront Endpoint Protection 2010 and SQL Server 2005 SP4.

In order to fix the error I added the -g startup parameter to the SQL Server service.  The -g startup parameter specifies the amount of memory in MB that SQL Server will leave available for memory allocations within the SQL Server process.  I set the option to 384MB.  More information on the startup parameter is available here:

To apply the startup parameter, open SQL Server Configuration Manager under Microsoft SQL Server 2005 -> Configuration Tools  on the start menu.

Right-click on the SQL Server service, choose properties and open the Advanced tab.

Add ;-g384 to the end of the existing startup parameters and restart the SQL Server service.