Error when sending scheduled report

We are using SQL Server 2005 SP2. We have setup the RS smtp configuration
and we we have created scheduled reports, but we get an error when the
report is emailed. If I understand correctly, the account name/password
that is used for authentication is the account name used for the SQL Server
Reporting Services service. I have edit the rsreportserver.config file and
changed the SMTPAuthenticate to 2. The SMTP server is configured to point
to an external SMTP server.
The error we receive is: 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.Make sure that you don't have an antivirus/firewall blocking port 25 because
it sounds like your report server is not able to innitiate a connection to
the mail server. You can also try telnetting your smtp server from your
report server on port 25 by typing "telnet smtpservername 25" at the comand
prompt on the report server. If that commnad times out then you have a
netwroking problem whether it be a physical problem, a routing problem or a
firewall problem.
"Tim Kelley" <tkelley@.company.com> wrote in message
news:uESIb0ljHHA.4936@.TK2MSFTNGP03.phx.gbl...
> We are using SQL Server 2005 SP2. We have setup the RS smtp configuration
> and we we have created scheduled reports, but we get an error when the
> report is emailed. If I understand correctly, the account name/password
> that is used for authentication is the account name used for the SQL
> Server Reporting Services service. I have edit the rsreportserver.config
> file and changed the SMTPAuthenticate to 2. The SMTP server is configured
> to point to an external SMTP server.
> The error we receive is: 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 was able to connect to the smtp server from our RS server. Any other
ideas?
Could it be an authentication issue?
Thanks,
Tim
"TJ Davis" <TJDavis@.sagu.edu> wrote in message
news:eumMVKmjHHA.4248@.TK2MSFTNGP06.phx.gbl...
> Make sure that you don't have an antivirus/firewall blocking port 25
> because it sounds like your report server is not able to innitiate a
> connection to the mail server. You can also try telnetting your smtp
> server from your report server on port 25 by typing "telnet smtpservername
> 25" at the comand prompt on the report server. If that commnad times out
> then you have a netwroking problem whether it be a physical problem, a
> routing problem or a firewall problem.
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:uESIb0ljHHA.4936@.TK2MSFTNGP03.phx.gbl...
>> We are using SQL Server 2005 SP2. We have setup the RS smtp
>> configuration and we we have created scheduled reports, but we get an
>> error when the report is emailed. If I understand correctly, the account
>> name/password that is used for authentication is the account name used
>> for the SQL Server Reporting Services service. I have edit the
>> rsreportserver.config file and changed the SMTPAuthenticate to 2. The
>> SMTP server is configured to point to an external SMTP server.
>> The error we receive is: 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.
>

Error Sending Email

Hello All
I have an issue sending email through a data driven subscription using
remote SMTP
ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
sending mail, CDO error -2147220977, will not resend
ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
sending email. System.Runtime.InteropServices.COMException (0x8004020F): The
server rejected one or more recipient addresses. The server response was:
550 must be authenticated
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
notification)
I am logging to my m/c as a user with admin rights (No domain login). The
Reporting Service Service account is the same as login account. SQL agent
also runs as same user account.
SMTP is a ISP's. I have changed
<SendEmailToUserAlias>False</SendEmailToUserAlias>. In my Antivirus console
in Access protection I disabled prevent Mass Mailing worms from port 25. The
From Email is a valid email that I use with SMTP Server.
I am not sure how to resolve this authentication error. I have read
somewhere Reporting Service Service Account should have permission on SMTP
server. I don't know how this is possible with remote SMTP server.
Can someone help me with this? I have been trying to resolve this couple
of days now.
RegardsOn Dec 13, 7:34 pm, "Achuthan Sundar" <achu...@.cubisone.com> wrote:
> Hello All
> I have an issue sending email through a data driven subscription using
> remote SMTP
> ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
> sending mail, CDO error -2147220977, will not resend
> ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
> sending email. System.Runtime.InteropServices.COMException (0x8004020F): The
> server rejected one or more recipient addresses. The server response was:
> 550 must be authenticated
> at ReportingServicesCDOInterop.MessageClass.Send()
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> I am logging to my m/c as a user with admin rights (No domain login). The
> Reporting Service Service account is the same as login account. SQL agent
> also runs as same user account.
> SMTP is a ISP's. I have changed
> <SendEmailToUserAlias>False</SendEmailToUserAlias>. In my Antivirus console
> in Access protection I disabled prevent Mass Mailing worms from port 25. The
> From Email is a valid email that I use with SMTP Server.
> I am not sure how to resolve this authentication error. I have read
> somewhere Reporting Service Service Account should have permission on SMTP
> server. I don't know how this is possible with remote SMTP server.
> Can someone help me with this? I have been trying to resolve this couple
> of days now.
> Regards
This link might help.
http://www.systemwebmail.com/faq/4.3.2.aspx
Regards,
Enrique Martinez
Sr. Software Consultant