Email doesn't work

I've just installed Reporting Services and am working through the
walkthroughs. I am stuck on one that deals with subscriptions and sending
reports via email. I used Report Manager to setup the report subscriptions,
but I get the following status message:
"Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files"
What am I doing wrong?
How do I setup ReportServer to send email?
I used the information in this article:
http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
I updated the rsreportserver.config file as directed. Here is the email
section:
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>MyServer</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>0</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>test@.borim.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>False</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>Either remove the value for the <SendUsing> tag or set it to 2.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"DaveM" <DaveM@.discussions.microsoft.com> wrote in message
news:87E61ABC-CB00-4803-A74E-243C8F863CB2@.microsoft.com...
> I've just installed Reporting Services and am working through the
> walkthroughs. I am stuck on one that deals with subscriptions and sending
> reports via email. I used Report Manager to setup the report
> subscriptions,
> but I get the following status message:
> "Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files"
>
> What am I doing wrong?
> How do I setup ReportServer to send email?
> I used the information in this article:
> http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
> I updated the rsreportserver.config file as directed. Here is the email
> section:
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>MyServer</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>0</SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>test@.borim.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>|||Sorry, I caught that and already changed it to 2.
Update on the problem:
I can send emails that only include the link, but not the report.
Furthermore, if I create a subscription that writes to a local file, it also
fails...?
1) IIS, SQL Server, Report Server all run under a domain admin account
2) I've installed Reporting Services SP1
3) I've made sure that the account that I am specifying for report access is
a domain admin (also tried local admin account) and has 'dbo' for access role
for all databases
4) All services run locally.
I'm stumped...
"Lukasz Pawlowski [MSFT]" wrote:
> Either remove the value for the <SendUsing> tag or set it to 2.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DaveM" <DaveM@.discussions.microsoft.com> wrote in message
> news:87E61ABC-CB00-4803-A74E-243C8F863CB2@.microsoft.com...
> > I've just installed Reporting Services and am working through the
> > walkthroughs. I am stuck on one that deals with subscriptions and sending
> > reports via email. I used Report Manager to setup the report
> > subscriptions,
> > but I get the following status message:
> >
> > "Failure sending mail: The Report Server has encountered a configuration
> > error; more details in the log files"
> >
> >
> >
> > What am I doing wrong?
> >
> > How do I setup ReportServer to send email?
> >
> > I used the information in this article:
> > http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
> >
> > I updated the rsreportserver.config file as directed. Here is the email
> > section:
> >
> > <Extension Name="Report Server Email"
> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> > <MaxRetries>3</MaxRetries>
> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <SMTPServer>MyServer</SMTPServer>
> > <SMTPServerPort></SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> >
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> >
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing>0</SendUsing>
> > <SMTPAuthenticate></SMTPAuthenticate>
> > <From>test@.borim.com</From>
> > <EmbeddedRenderFormats>
> >
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> >
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> >
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> >
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> >
> > <SendEmailToUserAlias>False</SendEmailToUserAlias>
> > <DefaultHostName></DefaultHostName>
> > <PermittedHosts></PermittedHosts>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
>
>|||Dave,
I'm having the same issue. My log file is getting the WinNT error 1355, and
there is currently a hotfix available for it (834859) I haven't tried it yet,
but someone did at the following url and it worked for them.
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/123eea5b7fc5edaa?q=authz+group:microsoft.public.sqlserver.reportingsvcs&hl=en&lr=&ie=UTF-8&rnum=4
"DaveM" wrote:
> Sorry, I caught that and already changed it to 2.
> Update on the problem:
> I can send emails that only include the link, but not the report.
> Furthermore, if I create a subscription that writes to a local file, it also
> fails...?
> 1) IIS, SQL Server, Report Server all run under a domain admin account
> 2) I've installed Reporting Services SP1
> 3) I've made sure that the account that I am specifying for report access is
> a domain admin (also tried local admin account) and has 'dbo' for access role
> for all databases
> 4) All services run locally.
> I'm stumped...
>
> "Lukasz Pawlowski [MSFT]" wrote:
> > Either remove the value for the <SendUsing> tag or set it to 2.
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> >
> > "DaveM" <DaveM@.discussions.microsoft.com> wrote in message
> > news:87E61ABC-CB00-4803-A74E-243C8F863CB2@.microsoft.com...
> > > I've just installed Reporting Services and am working through the
> > > walkthroughs. I am stuck on one that deals with subscriptions and sending
> > > reports via email. I used Report Manager to setup the report
> > > subscriptions,
> > > but I get the following status message:
> > >
> > > "Failure sending mail: The Report Server has encountered a configuration
> > > error; more details in the log files"
> > >
> > >
> > >
> > > What am I doing wrong?
> > >
> > > How do I setup ReportServer to send email?
> > >
> > > I used the information in this article:
> > > http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
> > >
> > > I updated the rsreportserver.config file as directed. Here is the email
> > > section:
> > >
> > > <Extension Name="Report Server Email"
> > > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> > > <MaxRetries>3</MaxRetries>
> > > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > > <Configuration>
> > > <RSEmailDPConfiguration>
> > > <SMTPServer>MyServer</SMTPServer>
> > > <SMTPServerPort></SMTPServerPort>
> > > <SMTPAccountName></SMTPAccountName>
> > >
> > > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > >
> > > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > > <SMTPUseSSL></SMTPUseSSL>
> > > <SendUsing>0</SendUsing>
> > > <SMTPAuthenticate></SMTPAuthenticate>
> > > <From>test@.borim.com</From>
> > > <EmbeddedRenderFormats>
> > >
> > > <RenderingExtension>MHTML</RenderingExtension>
> > > </EmbeddedRenderFormats>
> > >
> > > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > > <ExcludedRenderFormats>
> > >
> > > <RenderingExtension>HTMLOWC</RenderingExtension>
> > >
> > > <RenderingExtension>NULL</RenderingExtension>
> > > </ExcludedRenderFormats>
> > >
> > > <SendEmailToUserAlias>False</SendEmailToUserAlias>
> > > <DefaultHostName></DefaultHostName>
> > > <PermittedHosts></PermittedHosts>
> > > </RSEmailDPConfiguration>
> > > </Configuration>
> > > </Extension>
> >
> >
> >