Add Email as a delivery method for SCOM Scheduled Reports

Ever noticed that when setting up a scheduled report in System Center Operations Manager that E-mail is not available as a delivery method?  The only options I had in my environment by default were “Null Delivery Provider” and “Windows File Share.”  After searching the options in SCOM, and digging through my copy of “Systems Center Operations Manager Unleashed”, I discovered that this is intentional.  Since SCOM relies on Microsoft SQL Reporting for reports, this is actually an option that has to be configured on the SQL server.

Our environment uses SQL 2008 for the database server.  We run both the Operations Manager DB and the Data Warehouse DB on this server, in addition to the SQL Reporting Services.  If you want to configure E-mail as an option for SCOM scheduled reports delivery, log on to your SCOM database server, and go to Start, All Programs, Microsoft SQL Server 2008, Configuration Tools, Reporting Services Configuration Manager.  Connect to your server and server instance, then go to E-mail Settings on the left and enter your Sender Address and SMTP server name.  It should look something like this in SQL 2008:

Now you should have E-mail listed as a Delivery Method in SCOM for a scheduled report.