Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a ForeFront TMG 2010 SP1 installation. Reporting in the past has worked great.

However, I now need to find out why we've ripped through half our monthly quota in the first 6 days of the billing cycle, and TMG is failing me. The reports are generating OK, but there's just no data in them.

I can report just fine right up until the 1st of July. Any reports from the 1st of July just come back with no data.

I checked the logs inside MSDE and as far as I can tell the SQL data is all intact, but I know that TMG compiles these statistics nightly and stores them somewhere, but I can't find where to verify if they are working correctly.

Any ideas how to troubleshoot reporting in TMG 2010?

share|improve this question
    
You Aussies and your quotas...I guess this is the type of fun we have to look forward to in the states... :-( –  Jason Berg Jul 21 '11 at 23:11
    
The pricing for the new FTTP services they're rolling out contry-wide over the next 10 years have just been released as well. Anyone feel like paying $140/month for their internet? Thought not. –  Mark Henderson Jul 21 '11 at 23:13
    
I would gladly pay $140 for a 100/40 connection...if only it weren't for that pesky 200GB quota...Netflix alone would bankrupt me –  Jason Berg Jul 21 '11 at 23:20

1 Answer 1

up vote 1 down vote accepted

So, it turns out the event log was filled with hundreds of SQL Server Reporting errors about invalid credentials and bad linked servers. I went through every troubleshooting step on several MSDN articles to reset permissions, reset passwords, match GUIDs for reporting services, and nothing fixed it.

I ended up having to export all the TMG firewall rules and restore a backup from a few weeks ago. It all works OK now, but obviously all the logs are gone. No idea what caused it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.