Can someone recommend a good log analyzer, there are so many out there I am not sure which ones to recommend to the company I work for.
I have tried several of their free trial, but they limit the date range and or the database, and its hard to recommend a program without putting a load on it first.

We would like one that is full featured but still allows for custom reports or modification of their standard reports.

Also MSSQL database would be a plus.

I did search but the posts I found were php, based (though awstats said both, yet the site itself would not open under IE, took that as a bad sign).

Thanks

Check out SmarterTools, SmarterStats. Its quite popular among windows hosts and has a fairly simple interface.

http://www.smartertools.com