Post reply

SSRS has stopped sending email

  • February 6, 2010 at 10:45 pm

    #216351

    A server w/ SSRS installed on it has stopped sending email for the report subscriptions. It worked in the past.

    The SQL server is still sending out it's emails through the same server.

    I have double-checked the email settings in the Report Server Configuration.

    I have also deleted and re-entered those settings.

    But the emails still aren't being sent out, and I haven't been able to figure out why.

    Any ideas out there?

    Thanks,

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • February 7, 2010 at 8:17 pm

    #1115276

    SSRS uses CDO to enable the mail transport but if you check the rsreportserver.config file you will see the SMTP definition you may have to add values to it. CDO makes sending the mail easy but it is very old technology that is depreciated by the Asp.net team in 2005. So make sure you are using Exchange as your SMTP service and enter the relevant information in your config file.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply