RSSAmplifier

blog · Mar 18, 2020

SQL Server Reporting Services subscriptions fail to send email

0
Sign in to vote or save

robertwray.co.uk

The 'Subscriptions' tab in SSRS showing the status of a timed subscription that's failed to send by email

We've recently had reports that some scheduled reports that are emailed out haven't been sent/received, looking at SSRS the error that was showing was:

Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.

It turns out that the active directory account for the owner of the subscription was recently deleted. Re-creating the subscriptions with the owning account setup as an active user resolved the issue, though longer term we're going to move to getting users to manage their own subscriptions so that we don't have to keep track of, and refresh, subscriptions when the person who created them (invariably someone within IT) leaves the business.

About Rob

I've been interested in computing since the day my Dad purchased his first business PC (an Amstrad PC 1640 for anyone interested) which introduced me to MS-DOS batch programming and BASIC.

My skillset has matured somewhat since then, which you'll probably see from the posts here. You can read a bit more about me on the about page of the site, or check out some of the other posts on my areas of interest.


Read the original on robertwray.co.uk

Comments

Nothing yet. Say the first thing.

    Sign in to join the conversation.