Forefront TMG 2010 reports fail to create after Service Pack 1 is installed

2017-12-07T10:53:17+00:00 January 24th, 2011|Azure, Cloud, Windows|

We began receiving alerts from our SCOM 2007 R2 server that daily summary reports were failing to create on a TMG box shortly after installing TMG SP1.

Solution:

Run the “fixsqlserverlogin.vbs” script from the “Installing Forefront TMG SP1” TechNet article:

http://technet.microsoft.com/en-us/library/ff717843.aspx#fixsqlserverlogin_vbs