Error setting up Email delivery option through SSRS

• sarfaraz.vadsaria

  SSC Enthusiast

  Points: 113

  More actions

  May 27, 2008 at 3:25 am

  #380725

  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.

• mariusvw

  Newbie

  Points: 3

  More actions

  April 17, 2009 at 1:52 am

  #979455

  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

• Jayaram Krishnaswamy

  SSC Eights!

  Points: 980

  More actions

  April 21, 2009 at 2:07 pm

  #981773

  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