My technology flavour for the month… Microsoft Operations Manager (MOM) 2005. I’m helping a large local government organization implement MOM 2005 in their environment. Things are going super well and the people here are lightning fast in responding and working with me. This Australian government organization has their act more together than most private companies I’ve worked for. Good on them.
I guess I should first start by pointing out what ‘System Center’ is. Microsoft’s direction is to integrate MOM with SMS into a single product called System Center. In MOM 2005, the reporting bit is no longer ‘MOM Reporting’ but ‘System Center Reporting’. This is one of the first steps of introducing the ‘System Center’ term. Needless to say, that caused a bit of confusion with the guys here.
The problems I just encountered occurred during the creation of a report subscription:
Failure sending mail: The Report Server has encountered a configuration error; more details in the log files
SQL Reporting Services store their reports in a ‘logfiles’ subdirectory of the application’s directory which… is a subdirectory of SQL Server (default). Simply put, it should be something like:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
Anyhow, the log files did not tell me much. After some investigation, this is a known bug in SQL Reporting Services.
FIX: Subscriptions that use the e-mail delivery method for distribution may not deliver the report successfully in SQL Server 2000 Reporting Services
http://support.microsoft.com/kb/842440/
Fixed with a service pack:
SQL Reporting Services Service Pack 1
http://www.microsoft.com/downloads/details.aspx?familyid=580febf7-2972-40e7-bccf-6cd90ac2f464&displaylang=en#filelist
If you want the latest SQL Reporting Service Pack, visit this KB article:
How to obtain the latest service pack for SQL Server 2000 Reporting Services
http://support.microsoft.com/kb/842440/