Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email Error: The delivery extension for this subscription could not be loaded.

I am just getting started using scheduled emails and after setting up the
config file and setting up a schedule...I get the following error reported
on the RS (and no email):
"The delivery extension for this subscription could not be loaded."
when the subscription fires.
Can some one point me in the right direction on where to get more
information on this error. Does this mean that the EMAIL extension could
not be loaded or,
that the rendering format could not be loaded or,
what?
My first guess is that I did not set up the the email config section
correctly. What do you think and where on my system (logs) should I look to
get more details on this error. Win2003 server has a working SMTP relay
(tested with CDO VBS script).
thanks in advance.
dlrLook in the ReportServerService<date>.log file for more error information.
Also in the RSReportServer.config file make sure the SMTPServer element and
From element are filled in.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:eFPk2xKgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> I am just getting started using scheduled emails and after setting up the
> config file and setting up a schedule...I get the following error reported
> on the RS (and no email):
> "The delivery extension for this subscription could not be loaded."
> when the subscription fires.
> Can some one point me in the right direction on where to get more
> information on this error. Does this mean that the EMAIL extension could
> not be loaded or,
> that the rendering format could not be loaded or,
> what?
> My first guess is that I did not set up the the email config section
> correctly. What do you think and where on my system (logs) should I look
to
> get more details on this error. Win2003 server has a working SMTP relay
> (tested with CDO VBS script).
> thanks in advance.
> dlr
>|||ok Daniel. That problems seems to be a one time thing. Nothing in the log
file and repeated experiments today have basic email "working". Well
actually a problem HAS come up with the attachments but that is the subject
of another post.
thanks
dlr
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:udRV82KgEHA.592@.TK2MSFTNGP11.phx.gbl...
> Look in the ReportServerService<date>.log file for more error information.
> Also in the RSReportServer.config file make sure the SMTPServer element
and
> From element are filled in.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:eFPk2xKgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> > I am just getting started using scheduled emails and after setting up
the
> > config file and setting up a schedule...I get the following error
reported
> > on the RS (and no email):
> > "The delivery extension for this subscription could not be loaded."
> > when the subscription fires.
> > Can some one point me in the right direction on where to get more
> > information on this error. Does this mean that the EMAIL extension
could
> > not be loaded or,
> > that the rendering format could not be loaded or,
> > what?
> >
> > My first guess is that I did not set up the the email config section
> > correctly. What do you think and where on my system (logs) should I
look
> to
> > get more details on this error. Win2003 server has a working SMTP relay
> > (tested with CDO VBS script).
> >
> > thanks in advance.
> >
> > dlr
> >
> >
>