Home Forums Reporting Services SSRS 2014 Failure sending mail: Failure sending mail. RE: Failure sending mail: Failure sending mail.

  • April 12, 2018 at 9:58 am

    #1986620

    dweil - Thursday, April 12, 2018 9:20 AM

    I'm running into a strange problem.
    My ssrs subscription are working except for one report which was previously working.
    The report is automatically email to a group of users on a schedule.
    It continues to go out on schedule but all formatting is lost. It is more like a list of what is on the report.
    Interestingly on the the my subscriptions it shows "Failure sending mail: Failure sending mail".
    The report works fine when I run it manually with the same parameters.

    Check the Reporting Services log for additional information around the time that the subscription would have run. The logs are located at:
    Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\LogFiles
    It sounds like you should likely find some more information in the logs.

    First thing I thought though when you said it sued to work is that odd things happen with subscriptions if the owner is no longer an SSRS user. The owner id in the subscriptions table maps back to the user id in the users table. I'd check that just to make sure ownership of the subscription isn't an issue.

    Sue