Tuesday, March 27, 2012

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.
>

No comments:

Post a Comment