One of the downsides of Microsoft System Center is that you become an accidental SQL administrator. One of the powerful aspects of Operations Manager 2007 is Reporting. Having a year of data available for doing historical health and performance reports is very handy, e.g. SLA reporting, baseline performance analysis comparison, fault trend analysis.
Installing Reporting is tricky and not terribly well documented – is anything from MS these days – BLOGS AREN’T DOCUMENTATION!
This blog post (sigh!) goes through a checklist of what to look for when installing OpsMgr 2007 Reporting.