Showing posts with label walkthroughs. Show all posts
Showing posts with label walkthroughs. Show all posts

Sunday, March 11, 2012

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