Failure sending mail: Failure sending mail

Question

Failure sending mail: Failure sending mail

sizal0234

SSCrazy

Points: 2272
More actions
December 19, 2018 at 2:46 pm

#369731

USE [ReportServer]
go
SELECT
d.SubscriptionID
,e.name AS ReportName
,e.path AS ReportPath
,d.LastStatus
,d.LastRunTime
,u.UserName
FROM dbo.Subscriptions d
JOIN
dbo.Users AS u ON d.ownerid = u.UserID
JOIN
dbo.Catalog e ON itemid = report_oid
WHERE
d.LastStatus = 'Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.'
RESULT : I get the blank table with no values.
Environment Details : Report server is on Microsoft SQL Server 2016.
I am trying to schedule some simple reports and get error "Failure sending mail: Failure sending mail"

I have the correct smtp details setup in SQL Server reporting services config manager and also setup the time to 1800 seconds so the reports has good amount of time but it fails every attempt to send it to specific email.
What I am trying to do : Try to create a schedule to send the report to a specific email.
Please advise.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

sizal0234 - Wednesday, December 19, 2018 2:46 PM
USE [ReportServer]
go
SELECT
d.SubscriptionID
,e.name AS ReportName
,e.path AS ReportPath
,d.LastStatus
,d.LastRunTime
,u.UserName
FROM dbo.Subscriptions d
JOIN
dbo.Users AS u ON d.ownerid = u.UserID
JOIN
dbo.Catalog e ON itemid = report_oid
WHERE
d.LastStatus = 'Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.'
RESULT : I get the blank table with no values.
Environment Details : Report server is on Microsoft SQL Server 2016.
I am trying to schedule some simple reports and get error "Failure sending mail: Failure sending mail"

I have the correct smtp details setup in SQL Server reporting services config manager and also setup the time to 1800 seconds so the reports has good amount of time but it fails every attempt to send it to specific email.
What I am trying to do : Try to create a schedule to send the report to a specific email.
Please advise.

Are there any rows that actually meet the criteria expressed in the WHERE clause? If not, then the report is functioning correctly.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sizal0234 SSCrazy Points: 2272 More actions · Answer 2

Thanks, but why the report is not sent to the particular email. I open the reporting services configuration manager and check the scheule and it ran but with error message""Failure sending mail: Failure sending mail".

So do I have to look into report server to fix this or look into reporting services config mgr.
It is an issue with smtp details which I have setup under email settings in sql server config mgr?

The report is not being delivered to the email which I want to sent it to. The test email is working email.

Thom A SSC Guru Points: 99126 More actions · Answer 3

That SQL, on it's own, won't send an email anyway. How are you sending the email, via sp_send_dbmail? Can you include your FULL SQL, including the part that sends the email please?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Sue_H SSC Guru Points: 90860 More actions · Answer 4

sizal0234 - Thursday, December 20, 2018 7:12 PM
Thanks, but why the report is not sent to the particular email. I open the reporting services configuration manager and check the scheule and it ran but with error message""Failure sending mail: Failure sending mail".
So do I have to look into report server to fix this or look into reporting services config mgr.
It is an issue with smtp details which I have setup under email settings in sql server config mgr?
The report is not being delivered to the email which I want to sent it to. The test email is working email.

The Reporting Services log file would have a bit more information which might help narrow down the issue. Check the log file and the same date time in the failure you see for the last status failure in the subscriptions table. Search for: ERROR: Error sending email.
And you should find a bit more information about the failure.

Sue