Actually, this is more about a prereq for getting OpsMgr to install – that being the SQL Server 2005 Reporting Services. There are several things to watch for that can give you problems, not only with OpsMgr reporting, but also System Center Essentials reporting, as our new co-author John Joyner discovered.
- A couple of ways to validate that SRS reporting works properly – and if it doesn’t, don’t install OpsMgr or Essentials reporting:
- On the Operations Manager 2007 installation media there is a utlity in the Support Tools folder named ResetSRS.exe. Use of this utiilty was heavily recommended during the OpsMgr 2007 beta test cyles. The syntax is ResetSRS.exe MSSQLSERVER. Theoretically this should be done to reset SRS after you have removed a prior OpsMgr/Essentials installation. The Operations Manager 2007 Deployment Guide contains information about the ResetSRS utility.
- The last step is to modify the SRS Configuration. Click Start, Microsoft SQL Server 2005, Configuration Tools, and select Reporting Services Configuration.
- On the left side of the screen, select Web Service Identify, and on the right side click Apply.
- This restores the SRS installation to its original /pre-Operations Manger 2007 Reporting Server component state.