I have SSRS 2008 intalled on my desktop. As part of testing, I had to enable a report to be delievered to a set of users by e-mail on schedule.
So I tried to create a subscription. But in the subscription I could not see “E-Mail” option. The only option available was “Windows File share” option. I realized that I have not enabled E-Mail setting of my reporting services. So using Reporting Services Configuration manager, I enabled the E-Mail settings by providing a sender address and a remote SMTP server.
Then created a subscription for the report by selecting delivery method as E-Mail , send to address as my email id and created a schedule.
The subscription ran on schedule but failed with an error like
SSRS Failure sending mail: The server rejected the sender address. The server response was: 530 5.7.1 Client was not authenticated Mail will not be resent.
I rechecked my configurations. Everything looked fine. So I could not understand why the SMTP server was rejecting my account. After surfing for sometime , I came across this post in MSDN (http://msdn.microsoft.com/en-us/library/ms159155.aspx) which says that by default the authentication mode is anonymous . I understood why my SMTP thrown an error :(.
I was in for another surprise when I realized that Reporting Services configuration manager has no option to change this setting. Again flipping thru many pages in NET, finally I came across this post (http://blog.tech4him.com/2009/02/configure-sql-server-reporting-services-ssrs-for-non-default-smtp/) which confirmed that there is no way to change this setting thru UI. The only option available is to update the RSReportServer.config manually.
Modified my RSReportServer.config (which is available at ..\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer) and set the value for “SMTPAuthenticate” to 2 that is as below
Once this was done, my subscription started to deliver the report to my inbox without any issues.