Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent Expand / Collapse
Author
Message
Posted Friday, June 7, 2013 1:33 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:37 AM
Points: 154, Visits: 685
Hi All,
I have been trying to send ssrs report to users via email and i followed all the rules like configuring email settings like below:

Sender Address: User@Domain.com

Current SMTP Delivery Method: Use SMTP Server

SMTP Server: 10.5.8.50


and created new subscription to send it to myself first but i am getting this error:
Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.

So i looked into logs and i got this:

emailextension!WindowsService_11!1898!06/07/2013-13:51:59:: e ERROR: Error sending email. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
notification!WindowsService_11!1898!06/07/2013-13:51:59:: i INFO: Notification 43898ac1-9a0d-4541-8092-ee2c9aad1fce completed. Success: True, Status: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent., DeliveryExtension: Report Server Email, Report: HomeDepotTransactionHistory, Attempt 0
webserver!ReportServer_0-19!1d60!06/07/2013-13:52:01:: i INFO: Reporting Web Server stopped
appdomainmanager!DefaultDomain!1dfc!06/07/2013-13:52:49:: i INFO: Appdomain:34 ReportManager_MSSQLSERVER_0-21-130151011688350098 started.
appdomainmanager!ReportManager_0-21!1dfc!06/07/2013-13:52:53:: i INFO: RS authentication mode is 12; effective ASP.NET authentication mode is Windows. vdir=/Reports.
appdomainmanager!DefaultDomain!1dfc!06/07/2013-13:52:53:: i INFO: Appdomain:34 ReportManager_MSSQLSERVER_0-21-130151011688350098 initialized (#9).
ui!ReportManager_0-21!1dfc!06/07/2013-13:53:01:: i INFO: Registering with Software Usage Metrics Product:SQL Server 2012, Role:Microsoft SQL Server Reporting Services, RoleGuid:8cc0ac85-40f7-4886-9dab-021519800418
ui!ReportManager_0-21!1dfc!06/07/2013-13:53:01:: e ERROR: Software Usage Metrics initialize failed



The report is working manually but it is failing to send email.


In MSDN books online they say "The Report Server service must have Send As permissions on the SMTP server". I don't know how to set this. Can anyone tell me how to do this?

Also, Please let me know what exactly i am doing wrong..

Any help pleaseeee?


Post #1461208
Posted Friday, June 7, 2013 2:03 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 5:54 PM
Points: 130, Visits: 912
Does your Reporting Services Server have permissions to communicate with your SMTP Relay Server?

- Maybe a better question is, has this worked before or first time setting up email?


--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1461214
Posted Monday, June 10, 2013 8:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:37 AM
Points: 154, Visits: 685
This is the first time i have set up email settings in SSRS and trying to send email. So, SSRS needs to have permission on that SMTP server?
Post #1461584
Posted Monday, June 10, 2013 11:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:37 AM
Points: 154, Visits: 685
I have contacted my admin and he said that any server which is hitting the SMTP server should be able to send mail because there are no restrictions for that SMTP server.
Post #1461692
Posted Tuesday, June 11, 2013 6:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:37 AM
Points: 154, Visits: 685
I got the email by setting up the service account under report server configuration manager.

Thanks for your help.
Post #1462024
Posted Wednesday, June 19, 2013 3:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 1:04 AM
Points: 44, Visits: 17
Can you please explain what changes you did? I am having same problem.
Post #1465032
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse