Report Subscription sends an email once and fails afterwards

[brage98]

We are just moving to a new windows server 2008, hosting SQL-Server 2008 and Reports.

1. "E-mail Settings" is setup to use a remote smtp server (the server is in the same network as our new server)
2. The report-server is configured for dbmail (I've used EXEC msdb..sp_send_dbmail and it does work)
3. I've created a "subscription" to one of our reports
4. The very first time when I schedule the report the email is sent out
5. I reschedule the subscription so it runs within the next minute. Once the minute approaches, the status of the report is changed to "Mail Sent to ... [my email address]". However I never recieve the email
6. Every now and then, the status is changed to "The delivery extension for this subscription could not be loaded"

Any ideas??

 

[mrdenny]

You should post that in the SSRS forum, not the SSIS forum.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog