May 27, 2008 at 3:25 am
Hi,
I have deplyed a report on the SQL Reporting Services and having problem setting up Email delivery of the report with .pdf as option.
I have entered all the relevant information in the RSReportServer.config for Email settings like the SMTP server name and also set the SMTPAuthenticate to 2.
When I schedule the report at a particular time, it does not send the mail but displays following error on the Subscription screen:
Failure sending mail: The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available
I am using Remote SMTP Server andthe same is getting connected when I give following commant at command prompt:
>telnet 25
On executing this it says 'Ready to accept messages'.
Am I missing any settings as part of the email setup? What could be the problem.
Any help would be highly appreciated.
Thanks.
April 17, 2009 at 1:52 am
I am getting the same error
I went through a couple of sites and based the config on these values, but i still get the error.
I can telnet to the smtp server and send a smtp message via that ?
Settings modified:
SendUsing 2 SendUsing
SMTPAuthenticate 2 SMTPAuthenticate
SendEmailToUserAlias False SendEmailToUserAlias
April 21, 2009 at 2:07 pm
You also make sure that the SQL Server Agent Service is running.
You can start it from Control Panel or SQL SERVER Management Studio.
I have a step-by-step method to schedule reports. In fact there are 51 step-by-step hands-on exercises to learn SSRS 2008 my book, "Learn SQL Server Reporting Services 2008" by Packt Publishers.
Look up my blog at:
http://hodentek.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply