all groups > sql server reporting services > march 2006 >
You're in the

sql server reporting services

group:

E-mail subscription not a option


E-mail subscription not a option Robert Douglas
3/22/2006 4:50:28 PM
sql server reporting services:
Hi,

I'am running reporting services 2000 and I'am having a problem with e-mail
subscriptions. Here the low down.

My reports run without any problems but when I click on new subscription the
only option available is Report server file share. There's no option for
E-mail. At one point I was able to select the e-mail option but decided to
RE: E-mail subscription not a option Amarnath
3/22/2006 9:56:28 PM
Hi,
Fairly simple. Go to ReportServer directory and open RSreportserver.config
search for <Delivery> and inside that find for "Report Server Email" and add
the required things like from:, SMTP server, account name etc...
and restart the reporting server once; you should be getting this option as
well.
Amarnath

[quoted text, click to view]
RE: E-mail subscription not a option Robert Douglas
3/23/2006 4:08:27 AM
Amarnath,

I've tried that serveral times already and still the e-mail option is not
available. I'am on a corporate domain. Keep in mind that the option was there
a one time, but after I re-did the server I noticed this problem. This is the
delivery section from my RSreportserver.config:

<Delivery>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtprelay.montefiore.org</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>


[quoted text, click to view]
RE: E-mail subscription not a option Amarnath
3/23/2006 5:28:26 AM
Hi Robert,

Try giving IP address in <SMTPServer> section. I faced the same problem.

Amarnath

[quoted text, click to view]
RE: E-mail subscription not a option Robert Douglas
3/23/2006 6:18:31 AM
Same problem

[quoted text, click to view]
RE: E-mail subscription not a option Robert Douglas
3/23/2006 1:07:02 PM
Well I managed to get the e-mail option back but e-mail still not working.
I'll keep on trying.

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