After configuring an Email subscription, the subscription result shows: “Failure sending mail: One or more errors occurred.“. In this blog post I will share how I investigated and resolved one such failure.
My first step in troubleshooting this error was to query from the
ExecutionLog3
view inside theReportServer
database. I normally do this to check if and why a report subscription has failed its run.However, in this case all the log records showed success (
rsSuccess
status):
Read on to see what this indicates, how Eitan was able to troubleshoot the problem, and the ultimate fix.