Forefront TMG 2010 SP1 cannot write a log to a local SQL Server database

Consider one of the following scenarios:

• You install an English version of Microsoft Forefront Threat Management Gateway (TMG) 2010 Service Pack 1 (SP1) on a computer that is running a non-English version of a Windows operating system.
• You install a non-English version of TMG 2010 SP1 on a computer that is running an English version of a Windows operating system.

In these scenarios, many pending files for the TMG Large Logging Queue (LLQ) logging feature are created on the hard disk drive of the computer. Additionally, all the disk space on the hard disk drive may be exhausted when these files are created.

Additionally, the "Log formatting failure" alert is raised, and the following event entry is logged in the Application log:

Log Name: Application
Source: Microsoft Forefront TMG Control
Event ID: 8
Level: Error
Description: The %1 failed to log information to the SQL Server Express database %2 in the path %3. SQL Server Express error description: %4. The problem may be resolved by restarting the SQL Server Express (MSFW) service.

Note The %1, %2, %3, and %4 are placeholders for the dynamic information that is related to this event.

This issue occurs because some invalid data is created for some fields in the SQL database that is used for logging traffic. Therefore, SQL Server stops logging, and the LLQ files build up.

Note The LLQ files store the log-related data until the data can be committed to the SQL database.

Update information

To resolve this issue, install the software update that is described in the following Microsoft Knowledge Base (KB) article:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base: