Have you ever seen the following error in the TMG firewall console?
“Forefront TMG failed to connect to SQL Server for Forefront TMG Web filter logging. This failure may be due to a temporary condition, low resources, or inadequate permissions. SQL Server error description: Invalid or unknown table specified.”
We used to see that a bunch with the ISA firewall, but there might be other causes for the TMG firewall.
For more information, check out:
http://blogs.technet.com/b/isablog/archive/2012/04/30/issue-with-tmg-remote-sql-logging.aspx
HTH,
Deb
DEBRA LITTLEJOHN SHINDER
MVP (Enterprise Security)
“MS SECURITY”
[email protected]