DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2591272 - Last Review: October 31, 2011 - Revision: 2.0

SYMPTOMS

Consider the following scenario:
  • You have Microsoft Forefront Threat Management Gateway (TMG) 2010 Service Pack 1 (SP1) preinstalled on your computer.
  • TMG is configured to generate the daily summary data overnight.

In this scenario, the summary data is not created as expected. If you try to generate a report, the report is empty, and only the report template information is displayed. Additionally, you may receive the following Report Summary Generation Failure" message in the TMG Management console:
Description: The daily summary for day "dd/mm/yyyy" was not created. This may cause the report for this period to be inaccurate. Verify that no prior reporting configuration alerts exist, and that the reporting services on the designated Forefront TMG report server are running and accessible from all the array members. Use the source location 1001.105.7.0.9027.450 to report the failure. The failure is due to error: 0x80040e4d

CAUSE

When TMG is preinstalled, Sysprep.exe is run on the computer to generalize the installation. However, after the installation is generalized, certain parts of the TMG installation may not function as expected. To correct these issues, the IsaApplianceInit.exe application is run when TMG is first started. But when Service Pack 1 is part of the preinstallation package, the timing for configuring the credentials for SQL Server Reporting Services (SSRS) is affected. In this case, TMG and SSRS have different credentials, and this causes the problem that is described in the "Symptoms" section.

RESOLUTION

To resolve this problem, install the service pack that is described in the following Microsoft Knowledge Base article:
2555840  (http://support.microsoft.com/kb/2555840/ ) Description of Service Pack 2 for Microsoft Forefront Threat Management Gateway 2010

WORKAROUND

To work around this problem, reconfigure TMG Reporting Services to synchronize credentials between TMG and SSRS. To do this, follow these steps:
  1. Start Notepad.exe. To do this, click Start, click Run, type notepad in the Open box, and then click OK.
  2. Copy and paste the following code into the Notepad document:
    set root = CreateObject("FPC.Root")
    Set arr = root.GetContainingArray
     
    WScript.Echo "Creating new Reporting Services configuration id"
    Dim newConfigId
    Set TypeLib = CreateObject("Scriptlet.TypeLib") 
    newConfigId = TypeLib.Guid
    newConfigId = Left(newConfigId, Len(newConfigId)-2) 
    newConfigId = newConfigId & "#fpcISA2010SP1"
     
    arr.Reports.ReportingServicesProperties.ReportingServicesConfigurationId = newConfigId
    wscript.echo "Changing Reporting Services configuration id"
    arr.Save
    wscript.echo "Waiting for reload on array " & arr.name
    arr.WaitForReload
    wscript.echo "Done reloading array " & arr.name
     
    Dim adStateOpen
    adStateOpen = 1
     
    Set cnn = CreateObject("ADODB.Connection")
    cnn.ConnectionString = "Provider=SQLOLEDB;Data Source='(local)\ISARS';Integrated Security=SSPI"
    cnn.Open
    If cnn.State <> adStateOpen Then
        wscript.echo "Failed to open SQL connection: " & cnn.ConnectionString
    End If
     
    Dim sqlCommand
     
    sqlCommand = "IF EXISTS(SELECT * FROM ISA_RS_Db.sys.database_principals WHERE name='ISA_RS_USER')" + vbCr + vbLf
    sqlCommand = sqlCommand + "    BEGIN" + vbCr + vbLf
    sqlCommand = sqlCommand + "        PRINT 'User already have a role on this db'" + vbCr + vbLf
    sqlCommand = sqlCommand + "    END" + vbCr + vbLf
    sqlCommand = sqlCommand + "ELSE" + vbCr + vbLf
    sqlCommand = sqlCommand + "    BEGIN" + vbCr + vbLf
    sqlCommand = sqlCommand + "        PRINT 'User does not yet have a role on this db, adding...'" + vbCr + vbLf
    sqlCommand = sqlCommand + "        EXEC ISA_RS_Db..sp_adduser 'ISA_RS_USER'" + vbCr + vbLf
    sqlCommand = sqlCommand + "        EXEC ISA_RS_Db..sp_addrolemember 'db_owner', 'ISA_RS_USER'" + vbCr + vbLf
    sqlCommand = sqlCommand + "    END" + vbCr + vbLf
     
    wscript.echo "Will execute " & vbCr & vbLf & sqlCommand
    Set rs = cnn.Execute(sqlCommand)
    cnn.Close
     
    WScript.Echo "Done!"
  3. Save the file as "FixDailySum.vbs."
  4. On the TMG Report server, open an administrative command prompt, and then use the following command to run the script:
    cscript.exe FixDailySum.vbs

STATUS

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

REFERENCES

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684  (http://support.microsoft.com/kb/824684/ ) Description of the standard terminology that is used to describe Microsoft software updates


APPLIES TO
  • Microsoft Forefront Threat Management Gateway 2010 Enterprise
  • Microsoft Forefront Threat Management Gateway 2010 Standard
  • Microsoft Forefront Threat Management Gateway 2010 Service Pack 1
Keywords: 
kbfix kbbug kbexpertiseinter kbsurveynew KB2591272
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support