Hotfix Rollup 2 for Forefront TMG 2010 SP2 Now Available
The latest hotfix rollup for Forefront TMG 2010 SP2 is now available. This update includes fixes for the following issues:
KB2701952 – “Access is denied” status error when you use a delegated user account to try to monitor services in Forefront TMG 2010.
KB2700248 – A server that is running Forefront TMG 2010 may randomly stop processing incoming traffic.
KB2700806 – Connectivity verifier that uses the “HTTP request” connection method may not detect when a web server comes back online in Forefront TMG 2010.
KB2705787 – The Firewall service may intermittently crash when it processes client web proxy requests in a Forefront TMG 2010 environment.
KB2701943 – Error message when you try to join a Forefront 2010 server to an array: “The Operation Failed. Error code – 0x80070002 – the system cannot find the file specified”.
KB2705829 – The Firewall service may stop responding to all traffic on a server that is running Forefront TMG 2010.
KB2694478 – Dynamic Caching may incorrectly delete recently cached objects from a caching server that is running Forefront TMG 2010 or ISA Server 2006.
You can download hotfix rollup 2 for Forefront TMG 2010 SP2 here. After applying this update, the new Forefront TMG 2010 build number will be 7.0.9193.540.
Connect
Richard Hicks' Forefront TMG Blog 
I assume Forefront – Threat Management Gateway – SP2 – Update Rollup 1 is required before installing this Hotfix Rollup?
No. You should be able to install hotfix rollup 2 directly on Forefront TMG 2010 SP2.
Hello, I’m having problems when debugging the database as it grows and grows TMG and the idea is to use a script to delete old records. I’m ussing remote SQL logging. I make this two script but seems not to work I have an ODBC connection. Could you please help me?
——————————————————————————————-
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adUseClient = 3
Set objConnection = CreateObject(“ADODB.Connection”)
objConnection.ConnectionTimeout=1200
objConnection.Open “DSN=BaseTMGF;UID=xxx;PWD=xxxxxxxxx”
objConnection.EXECUTE “delete FROM dptmgf.dbo.FirewallLog WHERE logtime <= getdate()-60 "
objConnection.Close
——————————————————————————————-
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adUseClient = 3
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject("ADODB.Recordset")
objConnection.ConnectionTimeout=1200
objConnection.Open "DSN=BaseTMGW;UID=xxx;PWD=xxxxxxxx"
objConnection.EXECUTE "delete FROM dptmgw.dbo.WebProxyLog WHERE logtime <= getdate()-60 "
objConnection.Close
I’m not a SQL administrator at all, so I apologize I can’t really help you here. If anyone else has suggestions, please let us know! 🙂
is rollup 1 included in rollup 2? Because the fix we need is not listed for RU2.
Yes, it is. Hotfix rollups are always cumulative, so installing hotfix rollup 2 will include any and all hotfixes that were released in hotfix rollup 1.
I have a problem with VPN connections after installing roll up 1.
Hope rollup 2 fixes it.
Let’s hope so, but if it doesn’t let me know and I’ll see if I can help. 🙂
Hoftfix rollup 2 says it does not replace any previous hotfixes.
http://support.microsoft.com/kb/2689195
Also the KB for each hotfix rollup lists the file information. There are files in update rollup 1 that do not occur in hotfix rollup 2.
Hi Roger,
Hotfix rollups are indeed cumulative. The KB only lists the hotfixes that are new with the rollup. It is not a comprehensive list of all hotfixes included in the rollup. You can verify this for yourself by installing hotfix rollup 2 on Forefront TMG 2010 SP2, then check the version information for files not listed on the rollup. For example, dailysum.exe is listed on hotfix rollup 1 but not on the KB for hotfix rollup 2. However, the file version information indicates that it has been updated to version 7.0.9153.540 and has the same date and time stamp as other hotfixes included in rollup 2.