Groups | Blog | Home
all groups > sql server reporting services > january 2005 >

sql server reporting services : Email doesn't work


DaveM
1/26/2005 5:13:04 PM
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>
Lukasz Pawlowski [MSFT]
1/26/2005 7:53:39 PM
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.



[quoted text, click to view]

DaveM
1/26/2005 8:47:01 PM
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...


[quoted text, click to view]
David Siebert
1/28/2005 1:53:01 PM
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

[quoted text, click to view]
AddThis Social Bookmark Button