SQL Reporting Services - Email Subscriptions not sending email out
Hi, Platform is Microsoft SQL Server 2005 - 9.00.4053.00 (X64) Standard Edition (64-bit) on Windows Server 2008 Standard SP1 We have a Reporting Server here and we applied all the patches to bring Windows Server 2008 to SP2. Our Reporting service used to be able to send out email; but after this patch, the email feature seems to be unable to email anything. Here's some of the error in the error log files: ReportingServicesService!emailextension!1e!06/21/2011-06:31:06:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set Data. ---> System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded. ReportingServicesService!emailextension!1d!06/22/2011-00:02:14:: Error sending mail, CDO error -2147220977, will not resend ReportingServicesService!emailextension!1d!06/22/2011-00:02:14:: Error sending email. System.Runtime.InteropServices.COMException (0x8004020F): The server rejected one or more recipient addresses. The server response was: 550 5.7.1 Unable to relay for test@abc.com Any help is much appreciated!! Thanks. A~
June 22nd, 2011 3:14am

FYI - we changed something in the IIS Manager to make this work - something about Relay if I remember right.Thanks.
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2011 1:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics