emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

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 validation in ReportManager

Setting up a timed subscription in Reporting Services works just fine on our
server when the email address is joe@.domain.com. The Report server is set
up pointing to our SMTP server and works like a champ. Reports go out and
our chosen format (PDF) is generated and all is good.
When we enter a non-standard Email in the TO field (a RightFax email
address), the timed event runs and gives us a status of "The e-mail address
of one or more recipients is not valid."
Our question is: How can we turn off email validation within reporting
services so it will connect to the SMTP server (Exchange)?
ThanksHi,
This issue is usually caused by the fact that Email Relay is not turned on.
You may see something like the following in the Reporting Services Logfiles:
ReportingServicesService!emailextension!b14!10/14/2004-08:20:06:: Error
sending mail, CDO error -2147220977, will not resend
ReportingServicesService!emailextension!b14!10/14/2004-08:20:06:: Error
sending email. System.Runtime.InteropServices.COMException (0x8004020F):
The server
rejected one or more recipient addresses. The server response was: 550
5.7.1 Unable to relay for xxx@.xxx.xxx
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
ReportingServicesService!notification!b14!10/14/2004-08:20:06::
Notification 02710147-2025-4ed0-9c58-b37f12b64a79 completed. Success:
False, Status: The e-mail
address of one or more recipients is not valid., DeliveryExtension: Report
Server
Emai
If this is the case, you need to turn on email relay on the SMTP server.
If the error in the Reporting Services log file is not the same, please let
me know the exact error message so that we could get a better idea of the
issue.
The log file is usually located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Logfiles
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Reply-To: "isicoder" <isicoder@.newsgroups.nospam>
| From: "isicoder" <isicoder@.newsgroups.nospam>
| Subject: Email validation in ReportManager
| Date: Fri, 27 Jan 2006 12:35:16 -0800
| Lines: 16
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <OPD1vE4IGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 67.96.36.252
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67707
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Setting up a timed subscription in Reporting Services works just fine on
our
| server when the email address is joe@.domain.com. The Report server is
set
| up pointing to our SMTP server and works like a champ. Reports go out
and
| our chosen format (PDF) is generated and all is good.
|
| When we enter a non-standard Email in the TO field (a RightFax email
| address), the timed event runs and gives us a status of "The e-mail
address
| of one or more recipients is not valid."
|
| Our question is: How can we turn off email validation within reporting
| services so it will connect to the SMTP server (Exchange)?
|
| Thanks
|
|
|
|

Email subscription. Dynamic field of From.

hi,
I have a console application calling reporting service to generate email
subscription. It works but the email from field always show the fix address
in RSReportServer.config. Is there a way I can programmable change the From
field with my code?
Please suggest.
regards,
JoeNo, the from field can not be changed. You can change the Reply-To field.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> hi,
> I have a console application calling reporting service to generate email
> subscription. It works but the email from field always show the fix
> address
> in RSReportServer.config. Is there a way I can programmable change the
> From
> field with my code?
> Please suggest.
> regards,
> Joe|||That is correct, the from field cannot be changed programmatically per
request. You can usually use the reply-to header to achieve what you're
looking for.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> hi,
> I have a console application calling reporting service to generate email
> subscription. It works but the email from field always show the fix
> address
> in RSReportServer.config. Is there a way I can programmable change the
> From
> field with my code?
> Please suggest.
> regards,
> Joe|||Thanks for your reply.
Joe
"Lukasz Pawlowski [MSFT]" wrote:
> That is correct, the from field cannot be changed programmatically per
> request. You can usually use the reply-to header to achieve what you're
> looking for.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:50E4BCAD-DD67-494D-8D63-205D8E257BBD@.microsoft.com...
> > hi,
> > I have a console application calling reporting service to generate email
> > subscription. It works but the email from field always show the fix
> > address
> > in RSReportServer.config. Is there a way I can programmable change the
> > From
> > field with my code?
> > Please suggest.
> > regards,
> > Joe
>
>sql

email subscription to hotmail?

Hello...

I have a Virtual PC running SSRS 2005. I keep getting the following error when I try to specify my hotmail account as the To line in the email subscription:

"The e-mail address of one or more recipients is not valid."

I am trying to set it up such that I can send email subscriptions to my hotmail account, or at least let the SMTP Service accept these emails. I don't necesarily need to have these emails delivered, but I would like them to at least be accepted by the SMTP Service. I have added the following to my rsreportserver.config file:

<PermittedHosts>
<HostName>hotmail.com</HostName>
</PermittedHosts>

I am sure I need to configure the IIS SMTP Server settings somehow, does anyone know how to configure my local SMTP Service to allow @.hotmail.com email addresses to be placed into the "Drop" folder?

TIA

All,

After reading through some more posts online (searching through Google groups, yes Google groups MS folks!!!) I found what I needed to do. In fact, what I found does a lot more than I needed to do, it actually sends the email to the external account.

This is NOT a Reporting Services configuration issue. This is an SMTP Service configuration issue (as I suspected). Here is what I did. This may or may not be the "correct" way to do things, but it certainly works for my test environment (Note that this configuration probably shouldn't be used in a production enviornment!!!):

1. Open IIS Manager and right-click the "Default SMTP Virtual Server" and select "Properties".

2. On the Properties dialog, select the Access tab.

3. From the Access tab, click the "Relay..." button (near the bottom of the tab).

4. From the Relay Restrictions dialog, select the "All except the list below" option. Ensure that the "Allow all computers which successfully authenticate to relay, regardless of the list above" checkbox is checked.

5. Click OK on the Relay Restrictions dialog.

6. Click OK on the "Default SMTP Virtual Server Properties" dialog.

7. Stop, then Start the SMTP Service.

8. Setup your email subscription with your external email account and let it run.

Again, this worked for my development\test environment, but you should probably investigate further if you want to use this in a production environment as I am sure that setting up your SMTP Service for relay in this way probably opens it up to all sorts of attacks (like SPAM).

Hope that this helps others experiencing the same/similar issue!!

|||

Also:

9. I got rid of the items I added to the PermittedHosts element, this way I am not restricted to which domains I sent to. Obviously in a production enviornment you would not want to do this.

Email subscription Reported as Successful but not arriving in recipients inbox.

I have a report that is sent via email to a list of recipients. When I look at the subscription in 'My Subscriptions' the value in the Status column states that the message was 'sent successfully', however the email does not appear in the inboxes of any of the intended recipents. The report renders OK via the browser and only takes a few seconds to process. The subscription exports the report as an Excel file. The excel file is approx 8MB in size but this is still below the attachment size limit for internal emails within my organisation. The subscription is tied to a shared schedule. Other reports that are tied to the shared schedule are shown as successful in 'My Subscriptions' and also appear in the inboxes of recipients. All email address are correct.

I forgot to mention, the report was successfully received by all recipients until very recently and the report has not been modified since this time.

Has anyone come across this problem before.

Thanks

Mike

The Reporting Services e-mail delivery extension considers "sent successfully" to be "I handed it off to some SMTP forwarder". What happens to the e-mail after that is outside the scope of RS. You need to investigate within the e-mail system.

As a diagnostic, you might try delivering to an SMTP pickup folder temporarily to convince yourself that the Report Server is generating the e-mails. Find the rsReportServer.config file, change the "SendUsing" element to 1, specify some SMTPServerPickupDirectory, and try the delivery. If you get .EML files created in the specified folder, RS has done it's part of the delivery. Make sure you set SendUsing back to 2 or <blank> after you've done your test.

Here's a sample of the config file section you need to modify:

<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory>D:\Email</SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>1</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>_awtest@.Microsoft.Com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>

Email Subscription random failure

Hi folks,
I installed SP1 onto our development box in hope this would fix an issue with Email subscriptions failing on occasion to send. The problem is that random subscriptions are not firing after the report content is update and notification is not sent to the subscribers.
After installing SP1 on our dev boxes it appears to happen less often but still occasionally loosing one of the 9 email subscriptions i'm sending to myself. When i check the report the content of the snapshot was refreshed but the last run date for the subscription is for the previous day.
Any ideas?Do you see anything in the log files indicating a failure?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote in
message news:3F1EAEF9-4902-4C10-B3A7-370E00E92750@.microsoft.com...
> Hi folks,
> I installed SP1 onto our development box in hope this would fix an issue
with Email subscriptions failing on occasion to send. The problem is that
random subscriptions are not firing after the report content is update and
notification is not sent to the subscribers.
> After installing SP1 on our dev boxes it appears to happen less often but
still occasionally loosing one of the 9 email subscriptions i'm sending to
myself. When i check the report the content of the snapshot was refreshed
but the last run date for the subscription is for the previous day.
> Any ideas?|||Just to make sure, you are not expecting these on History snapshots are you?
Only report execution snapshots will generate the correct event for a
subscription.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote in
message news:C7D230A4-D3B0-47C4-922F-86EECC7EF7F2@.microsoft.com...
> I checked all the log files and there are no entries at all for those
items. It seems to be only happening when you setup subscriptions to send
when content is refreshed.
> "Daniel Reib [MSFT]" wrote:
> > Do you see anything in the log files indicating a failure?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote
in
> > message news:3F1EAEF9-4902-4C10-B3A7-370E00E92750@.microsoft.com...
> > > Hi folks,
> > >
> > > I installed SP1 onto our development box in hope this would fix an
issue
> > with Email subscriptions failing on occasion to send. The problem is
that
> > random subscriptions are not firing after the report content is update
and
> > notification is not sent to the subscribers.
> > >
> > > After installing SP1 on our dev boxes it appears to happen less often
but
> > still occasionally loosing one of the 9 email subscriptions i'm sending
to
> > myself. When i check the report the content of the snapshot was
refreshed
> > but the last run date for the subscription is for the previous day.
> > >
> > > Any ideas?
> >
> >
> >|||These email subscriptions are on the report execution snapshots. For now i'm going to be working around the issue and just setting up a seperate schedule for the emailing to (hopefully) occure after all reports are rendered.
"Daniel Reib [MSFT]" wrote:
> Just to make sure, you are not expecting these on History snapshots are you?
> Only report execution snapshots will generate the correct event for a
> subscription.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote in
> message news:C7D230A4-D3B0-47C4-922F-86EECC7EF7F2@.microsoft.com...
> > I checked all the log files and there are no entries at all for those
> items. It seems to be only happening when you setup subscriptions to send
> when content is refreshed.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Do you see anything in the log files indicating a failure?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote
> in
> > > message news:3F1EAEF9-4902-4C10-B3A7-370E00E92750@.microsoft.com...
> > > > Hi folks,
> > > >
> > > > I installed SP1 onto our development box in hope this would fix an
> issue
> > > with Email subscriptions failing on occasion to send. The problem is
> that
> > > random subscriptions are not firing after the report content is update
> and
> > > notification is not sent to the subscribers.
> > > >
> > > > After installing SP1 on our dev boxes it appears to happen less often
> but
> > > still occasionally loosing one of the 9 email subscriptions i'm sending
> to
> > > myself. When i check the report the content of the snapshot was
> refreshed
> > > but the last run date for the subscription is for the previous day.
> > > >
> > > > Any ideas?
> > >
> > >
> > >
>
>

e-mail subscription quit working - can't figure out why

Hi All,
I am using SQL Reporting Services MOM Reporting. I set up some reports and
they have been delivering flawlessley now for over a month. Now this morning
I got the error:
"Failure sending mail: The transport failed to connect to the server. "
It isn't descriptive enough to know what exactly failed. I can ping and
telnet to the SMTP port of the mail server and not being blocked. Also, the
same settings are being used for alerts from MOM without any problems. Is
there a way to run a test or get a better log to know what the error is?
This error is useless.
Thanks,
--GREG--I had experienced similar behavior. We resolved this by changing the
SMTP server specified in the Email Settings within Report Services
Configuration tool from the server name to the mail server's IP
address. Hope this helps!
Midas

Email Subscription Problem

I have an install of Reporting Services which when trying to send an email based subscription, returns the following error;

Failure sending mail: Retrieving the COM class factory for component with CLSID {CD000001-8B95-11D1-82DB-00C04FB1625D} failed due to the following error: 80040154.

No errors are shown in the RS logs or the events logs.

Does anybody have any ideas what could be causing this?

I don't know what version you are using but when it first came out it was hard for most people to install it but I did not get a hard time because I ignored all Windows questions. So I remember it asking for Exchange server you will use with it, if you did not configure Exchange, SMTP or SQL Server Agent to use for your mail that could be the reason for the error. Hope this helps.|||Thanks for your reply. I've double-checked all the configuration and everything appears fine. :(sql

Email Subscription Problem

Regards,
When a non administrative person sets up an email subscription to a
particular report, the "to" field defaults to their login name rather than
their email address.
So for jsmith@.microsoft.com, the "to" field defaults to "jsmith" and is read
only so it can't be changed.
Once the subscription is made, the email goes to jsmith, which doesn't
resolve to anything causing a bounce-back.
Is there a setting to tell Reporting Services to use the AD email address
for users if available? Or is there a way to default the domain for missing
domains?
There has to be a setting in one of the config files.
Any help would be greatly appreciated!
Benjamin PierceIf all you need is to add host name to the email, there is a DefaultHostName
element in the RSReportServer config file. This will add the host name to
any email address that does not have one.
If you want all users to be able to edit the TO line set the
SendEmailToUserAlias element to false and then every user will have a blank
TO line that they can set.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:OmZZyvLTFHA.3264@.TK2MSFTNGP15.phx.gbl...
> Regards,
> When a non administrative person sets up an email subscription to a
> particular report, the "to" field defaults to their login name rather than
> their email address.
> So for jsmith@.microsoft.com, the "to" field defaults to "jsmith" and is
> read
> only so it can't be changed.
> Once the subscription is made, the email goes to jsmith, which doesn't
> resolve to anything causing a bounce-back.
> Is there a setting to tell Reporting Services to use the AD email address
> for users if available? Or is there a way to default the domain for
> missing
> domains?
> There has to be a setting in one of the config files.
> Any help would be greatly appreciated!
> Benjamin Pierce
>|||Thanks Daniel,
Adding a DefaultHostName worked like a charm. VERY MUCH APPRECIATED!
Benjamin Pierce
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:O9fs3QQTFHA.3188@.TK2MSFTNGP09.phx.gbl...
> If all you need is to add host name to the email, there is a
DefaultHostName
> element in the RSReportServer config file. This will add the host name to
> any email address that does not have one.
> If you want all users to be able to edit the TO line set the
> SendEmailToUserAlias element to false and then every user will have a
blank
> TO line that they can set.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> news:OmZZyvLTFHA.3264@.TK2MSFTNGP15.phx.gbl...
> > Regards,
> >
> > When a non administrative person sets up an email subscription to a
> > particular report, the "to" field defaults to their login name rather
than
> > their email address.
> >
> > So for jsmith@.microsoft.com, the "to" field defaults to "jsmith" and is
> > read
> > only so it can't be changed.
> >
> > Once the subscription is made, the email goes to jsmith, which doesn't
> > resolve to anything causing a bounce-back.
> >
> > Is there a setting to tell Reporting Services to use the AD email
address
> > for users if available? Or is there a way to default the domain for
> > missing
> > domains?
> >
> > There has to be a setting in one of the config files.
> >
> > Any help would be greatly appreciated!
> >
> > Benjamin Pierce
> >
> >
>

Email Subscription not working - help please

Nothing shows up under the "Last Run" column. No error msg or entry in
reporting services or SMTP log.
Looks like reporting server is completly ignoring the subscription entry.
I'm using "once" option and selecting a time just 10-15 minutes ahead.
Here are the entries in my RSReportServer.config file:
----
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>150.8.111.82</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>altbill@.discountcar.com</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>
----
What could be wrong... any ideas...
Thanks
AJHi, I have the exact same problem. I'm running win2003, and you?
"Amit Jain" wrote:
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</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>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>
>|||I've tried it on Win2K server and Win2K professional, same issue on both
installations.
"Hennie" <Hennie@.discussions.microsoft.com> wrote in message
news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
> Hi, I have the exact same problem. I'm running win2003, and you?
> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server FileShare"
>> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <FileShareConfiguration>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> </FileShareConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="Report Server Email"
>> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</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>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>|||I fixed it by starting the ReportServer service. I should've have checked
it before posting.
"AJ" <amitjn_ca@.yahoo.ca> wrote in message
news:uIW6bH7AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> I've tried it on Win2K server and Win2K professional, same issue on both
> installations.
> "Hennie" <Hennie@.discussions.microsoft.com> wrote in message
> news:15DCD777-B85F-4D3D-893C-618D7B138F94@.microsoft.com...
>> Hi, I have the exact same problem. I'm running win2003, and you?
>> "Amit Jain" wrote:
>> Nothing shows up under the "Last Run" column. No error msg or entry in
>> reporting services or SMTP log.
>> Looks like reporting server is completly ignoring the subscription
>> entry.
>> I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> Here are the entries in my RSReportServer.config file:
>> ----
>> <Extensions>
>> <Delivery>
>> <Extension Name="Report Server FileShare"
>> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <FileShareConfiguration>
>> <ExcludedRenderFormats>
>> <RenderingExtension>HTMLOWC</RenderingExtension>
>> <RenderingExtension>NULL</RenderingExtension>
>> </ExcludedRenderFormats>
>> </FileShareConfiguration>
>> </Configuration>
>> </Extension>
>> <Extension Name="Report Server Email"
>> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> <MaxRetries>3</MaxRetries>
>> <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> <Configuration>
>> <RSEmailDPConfiguration>
>> <SMTPServer>150.8.111.82</SMTPServer>
>> <SMTPServerPort></SMTPServerPort>
>> <SMTPAccountName></SMTPAccountName>
>> <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> <SMTPUseSSL></SMTPUseSSL>
>> <SendUsing></SendUsing>
>> <SMTPAuthenticate></SMTPAuthenticate>
>> <From>altbill@.discountcar.com</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>
>> ----
>> What could be wrong... any ideas...
>> Thanks
>> AJ
>>
>|||In general, when you encounter issues like this, check the reporting
services log files. You should see a event polling message and status for
any notifications that are entered. This will also tell you if there are
errors. If you do not see any service log files, you'll need to start the
service called reportserver
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
> Nothing shows up under the "Last Run" column. No error msg or entry in
> reporting services or SMTP log.
> Looks like reporting server is completly ignoring the subscription entry.
> I'm using "once" option and selecting a time just 10-15 minutes ahead.
> Here are the entries in my RSReportServer.config file:
> ----
> <Extensions>
> <Delivery>
> <Extension Name="Report Server FileShare"
> Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <FileShareConfiguration>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> </FileShareConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>150.8.111.82</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>altbill@.discountcar.com</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>
> ----
> What could be wrong... any ideas...
> Thanks
> AJ
>|||Like Lukasz says, check the report Server Log, if any error occured you will
find them there, in the first example of Amit i would suggest looking in the
logs of the SMTP Server (For example you could send the EMail temporary to
an virtual SMTP Server where you have full control of and relay it to the
productive server to check the logs) or just to check if the SMTP Server
accepted relayed EMails to conenct to the mail server via telnet.
--> telnet Mailserver 25
Rest can be found here:
http://www.yuki-onna.co.uk/email/smtp.html
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Koen" <Koen@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F6365949-8F76-41B7-B74A-182A7A5869C6@.microsoft.com...
> Is there an internal clock or so in reporting services ? Because i'm
> facing
> the same problem, but when i check my log files, i see that the time when
> these files were created is impossible (eg: 2 AM, when nobody's at the
> office
> and the server is shut down).
> Thanks in advance
> "Lukasz Pawlowski [MSFT]" wrote:
>> In general, when you encounter issues like this, check the reporting
>> services log files. You should see a event polling message and status
>> for
>> any notifications that are entered. This will also tell you if there are
>> errors. If you do not see any service log files, you'll need to start
>> the
>> service called reportserver
>> -Lukasz
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "Amit Jain" <amitjn_ca@.yahoo.ca> wrote in message
>> news:eNlilGyAFHA.2540@.TK2MSFTNGP09.phx.gbl...
>> > Nothing shows up under the "Last Run" column. No error msg or entry in
>> > reporting services or SMTP log.
>> > Looks like reporting server is completly ignoring the subscription
>> > entry.
>> > I'm using "once" option and selecting a time just 10-15 minutes ahead.
>> > Here are the entries in my RSReportServer.config file:
>> > ----
>> > <Extensions>
>> > <Delivery>
>> > <Extension Name="Report Server FileShare"
>> > Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
>> > <MaxRetries>3</MaxRetries>
>> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> > <Configuration>
>> > <FileShareConfiguration>
>> > <ExcludedRenderFormats>
>> > <RenderingExtension>HTMLOWC</RenderingExtension>
>> > <RenderingExtension>NULL</RenderingExtension>
>> > </ExcludedRenderFormats>
>> > </FileShareConfiguration>
>> > </Configuration>
>> > </Extension>
>> > <Extension Name="Report Server Email"
>> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
>> > <MaxRetries>3</MaxRetries>
>> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
>> > <Configuration>
>> > <RSEmailDPConfiguration>
>> > <SMTPServer>150.8.111.82</SMTPServer>
>> > <SMTPServerPort></SMTPServerPort>
>> > <SMTPAccountName></SMTPAccountName>
>> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
>> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
>> > <SMTPUseSSL></SMTPUseSSL>
>> > <SendUsing></SendUsing>
>> > <SMTPAuthenticate></SMTPAuthenticate>
>> > <From>altbill@.discountcar.com</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>
>> > ----
>> > What could be wrong... any ideas...
>> > Thanks
>> > AJ
>> >
>>

E-mail subscription not a option

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-do my 2003 server. Any help with this issue would be more than welcomed.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
"Robert Douglas" wrote:
> 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-do my 2003 server. Any help with this issue would be more than welcomed.|||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>
"Amarnath" wrote:
> 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
> "Robert Douglas" wrote:
> > 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-do my 2003 server. Any help with this issue would be more than welcomed.|||Hi Robert,
Try giving IP address in <SMTPServer> section. I faced the same problem.
Amarnath
"Robert Douglas" wrote:
> 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>
>
> "Amarnath" wrote:
> > 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
> >
> > "Robert Douglas" wrote:
> >
> > > 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-do my 2003 server. Any help with this issue would be more than welcomed.|||Same problem
"Robert Douglas" wrote:
> 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-do my 2003 server. Any help with this issue would be more than welcomed.|||Well I managed to get the e-mail option back but e-mail still not working.
I'll keep on trying.
"Amarnath" wrote:
> Hi Robert,
> Try giving IP address in <SMTPServer> section. I faced the same problem.
> Amarnath
> "Robert Douglas" wrote:
> > 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>
> >
> >
> > "Amarnath" wrote:
> >
> > > 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
> > >
> > > "Robert Douglas" wrote:
> > >
> > > > 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-do my 2003 server. Any help with this issue would be more than welcomed.

Email subscription Issue

We have deployed SSRS 2005 on internet using Forms authentication. every thing works just fine except the email subscription;

when a user who is part of browser role (manage individual subscription) clicks on new subscription his To field is grayed out (unable to modify) and account showing in it is the service account we use to run reporting service.

we need to give users permission to specity To, CC, BCC fields without letting them see other subscriptions.

can you help us configuring this?

Hi Aneel-

You need to go into the rsreportserver.config file located in the ReportServer folder and look for the "<SendEmailToUserAlias>" node. If it is "False", change it to "True" and you'll be able to enter e-mail addresses to send to. You will only get the "To" field, not "Cc" or "Bcc" fields.

Note you may have to restart IIS.

Regards,
Scott

Email Subscription into Excel

I am running Reporting Services 2000 and I have several email subscriptions
sending out reports rendered into Excel. On two of the reports the Excel
file contains a document map. How can I disable the document map from being
created? These subscriptions have been created using the standard reporting
services interface. Any help would be appreciated.
Thanks,
JeffJeff,
You have to disable the documentmap in the report itself. To my knowledge
you can not disbable this only when exporting (if you know how, let me know
:).
Perry
"Jeff McIntire" <JeffMcIntire@.discussions.microsoft.com> wrote in message
news:E3A7BB06-A11B-402C-A29E-79DE88A73F30@.microsoft.com...
>I am running Reporting Services 2000 and I have several email subscriptions
> sending out reports rendered into Excel. On two of the reports the Excel
> file contains a document map. How can I disable the document map from
> being
> created? These subscriptions have been created using the standard
> reporting
> services interface. Any help would be appreciated.
> Thanks,
> Jeff
>sql

EMail subscription fails with LOGON FAILED

I am setting up SQL Reporting enterprise. I can't get email subscriptions to
work. SQL Reporting enterprise is installed and the report works fine when
generated. The security is setup to use a windows account and store
credentials on server. This account has the SA role within SQL and the
database where data is being pulled from. Platform is Win2003 - fully
patched with Reporting service pack 1
There is nothing in the event logs indicating any type of failure.
The SMTP server is setup as remote SMTP server and I've verified the config
file to ensure it is setup correctly. Since I'm getting a logon failure -
I'm not sure its really an email issue at this point. Specifically, the
config file is set up as:
<SMTPServer>172.24.1.25</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate>0</SMTPAuthenticate>
<From>SQLREP@.correctdomain.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
At this time out out of ideas - can anyone suggest where to look?What is the login failure you're recieving? Is it in the report server log
file when you try to perform the delivery?
If so the report server service account may not have rights to push email to
your SMTP server. You might need to drop them to the file system and use a
local SMTP server to pass them along to your outbound SMTP server.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
>I am setting up SQL Reporting enterprise. I can't get email subscriptions
>to
> work. SQL Reporting enterprise is installed and the report works fine
> when
> generated. The security is setup to use a windows account and store
> credentials on server. This account has the SA role within SQL and the
> database where data is being pulled from. Platform is Win2003 - fully
> patched with Reporting service pack 1
> There is nothing in the event logs indicating any type of failure.
> The SMTP server is setup as remote SMTP server and I've verified the
> config
> file to ensure it is setup correctly. Since I'm getting a logon failure -
> I'm not sure its really an email issue at this point. Specifically, the
> config file is set up as:
> <SMTPServer>172.24.1.25</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate>0</SMTPAuthenticate>
> <From>SQLREP@.correctdomain.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> At this time out out of ideas - can anyone suggest where to look?
>|||Thank you for the post. The logon failed is being shown in the web interface
under subscriptions.
The reportserverservice does show a login failure - although I can't imagine
why. I've setup the job with several credentials and all fail. (Including
Domain Admin role) The Reporting service is currently running as a network
service but I have also run it will a privledge domain account. Same error.
I am able to send to the SMTP server from this server without authentication.
I'm still stumped!
From the log file:
ReportingServicesService!dbpolling!6f0!2/10/2005-08:43:09::
NotificationPolling processing item 052e0da7-4e8f-4804-84fb-76bb1b373d62
ReportingServicesService!library!6f0!02/10/2005-08:43:09:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!6f0!02/10/2005-08:43:10:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
failure: unknown user name or bad password.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
at
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
-- End of inner exception stack trace --
ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: e ERROR:
Error occured processing notification. Logon failed.
ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: Notification
052e0da7-4e8f-4804-84fb-76bb1b373d62 completed. Success: False, Status:
Logon failed., DeliveryExtension: Report Server Email, Report: Expired
Enhancements, Attempt 0
ReportingServicesService!dbpolling!6f0!02/10/2005-08:43:10::
NotificationPolling finished processing item
052e0da7-4e8f-4804-84fb-76bb1b373d62
"Lukasz Pawlowski [MSFT]" wrote:
> What is the login failure you're recieving? Is it in the report server log
> file when you try to perform the delivery?
> If so the report server service account may not have rights to push email to
> your SMTP server. You might need to drop them to the file system and use a
> local SMTP server to pass them along to your outbound SMTP server.
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
> >I am setting up SQL Reporting enterprise. I can't get email subscriptions
> >to
> > work. SQL Reporting enterprise is installed and the report works fine
> > when
> > generated. The security is setup to use a windows account and store
> > credentials on server. This account has the SA role within SQL and the
> > database where data is being pulled from. Platform is Win2003 - fully
> > patched with Reporting service pack 1
> >
> > There is nothing in the event logs indicating any type of failure.
> >
> > The SMTP server is setup as remote SMTP server and I've verified the
> > config
> > file to ensure it is setup correctly. Since I'm getting a logon failure -
> > I'm not sure its really an email issue at this point. Specifically, the
> > config file is set up as:
> >
> > <SMTPServer>172.24.1.25</SMTPServer>
> > <SMTPServerPort>25</SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate>0</SMTPAuthenticate>
> > <From>SQLREP@.correctdomain.com</From>
> > <EmbeddedRenderFormats>
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> >
> > At this time out out of ideas - can anyone suggest where to look?
> >
>
>|||Update: I failed to use RSKEYMGNT to export the key prior to resetting the
service account context. I set it back and will change the account properly
to see if this resolves the issue.
"Bill" wrote:
> Thank you for the post. The logon failed is being shown in the web interface
> under subscriptions.
> The reportserverservice does show a login failure - although I can't imagine
> why. I've setup the job with several credentials and all fail. (Including
> Domain Admin role) The Reporting service is currently running as a network
> service but I have also run it will a privledge domain account. Same error.
> I am able to send to the SMTP server from this server without authentication.
> I'm still stumped!
> From the log file:
> ReportingServicesService!dbpolling!6f0!2/10/2005-08:43:09::
> NotificationPolling processing item 052e0da7-4e8f-4804-84fb-76bb1b373d62
> ReportingServicesService!library!6f0!02/10/2005-08:43:09:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!6f0!02/10/2005-08:43:10:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
> failed., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
> failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
> failure: unknown user name or bad password.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
> at
> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
> -- End of inner exception stack trace --
> ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: e ERROR:
> Error occured processing notification. Logon failed.
> ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: Notification
> 052e0da7-4e8f-4804-84fb-76bb1b373d62 completed. Success: False, Status:
> Logon failed., DeliveryExtension: Report Server Email, Report: Expired
> Enhancements, Attempt 0
> ReportingServicesService!dbpolling!6f0!02/10/2005-08:43:10::
> NotificationPolling finished processing item
> 052e0da7-4e8f-4804-84fb-76bb1b373d62
>
> "Lukasz Pawlowski [MSFT]" wrote:
> > What is the login failure you're recieving? Is it in the report server log
> > file when you try to perform the delivery?
> >
> > If so the report server service account may not have rights to push email to
> > your SMTP server. You might need to drop them to the file system and use a
> > local SMTP server to pass them along to your outbound SMTP server.
> >
> > -Lukasz
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Bill" <Bill@.discussions.microsoft.com> wrote in message
> > news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
> > >I am setting up SQL Reporting enterprise. I can't get email subscriptions
> > >to
> > > work. SQL Reporting enterprise is installed and the report works fine
> > > when
> > > generated. The security is setup to use a windows account and store
> > > credentials on server. This account has the SA role within SQL and the
> > > database where data is being pulled from. Platform is Win2003 - fully
> > > patched with Reporting service pack 1
> > >
> > > There is nothing in the event logs indicating any type of failure.
> > >
> > > The SMTP server is setup as remote SMTP server and I've verified the
> > > config
> > > file to ensure it is setup correctly. Since I'm getting a logon failure -
> > > I'm not sure its really an email issue at this point. Specifically, the
> > > config file is set up as:
> > >
> > > <SMTPServer>172.24.1.25</SMTPServer>
> > > <SMTPServerPort>25</SMTPServerPort>
> > > <SMTPAccountName></SMTPAccountName>
> > > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > > <SMTPUseSSL></SMTPUseSSL>
> > > <SendUsing></SendUsing>
> > > <SMTPAuthenticate>0</SMTPAuthenticate>
> > > <From>SQLREP@.correctdomain.com</From>
> > > <EmbeddedRenderFormats>
> > > <RenderingExtension>MHTML</RenderingExtension>
> > > </EmbeddedRenderFormats>
> > > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > > <ExcludedRenderFormats>
> > > <RenderingExtension>HTMLOWC</RenderingExtension>
> > > <RenderingExtension>NULL</RenderingExtension>
> > > </ExcludedRenderFormats>
> > > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> > >
> > > At this time out out of ideas - can anyone suggest where to look?
> > >
> >
> >
> >|||I am getting a logon failed when I set up my subscription through th
GUI in Report Manager. I confirmed that the SMTP settings wer
correct in the RSReportSever.config file. The Log is as follows: Ca
you help?
ReportingServicesService!library!d84!09/21/2005-14:39:10:: i INFO
Initializing EnableIntegratedSecurity to 'True' as specified i
Server system properties
ReportingServicesService!library!d84!09/21/2005-14:39:10:: e ERROR
Throwin
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException
Logon failed.,
Info
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException
Logon failed. --> System.Runtime.InteropServices.COMExceptio
(0x8007052E): Logon failure: unknown user name or ba
password. a
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int3
errorCode, IntPtr errorInfo
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(Strin
pUserName, String pDomain, String pPassword, Boolean bTryRemote
IntPtr& pImpToken
a
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(Strin
userName, String userPwd, String domain
-- End of inner exception stack trace --
ReportingServicesService!notification!d84!09/21/2005-14:39:10::
ERROR: Error occured processing notification. Logon failed
ReportingServicesService!notification!d84!09/21/2005-14:39:10:
Notification 4105c963-0eb9-4f69-bbbc-81ab27964a43 completed.
Success: False, [b:f30cd15b21]Status: Logon failed.
DeliveryExtension: Report Server [/b:f30cd15b21]Email, Report
Incomplete Loan Applications, Attempt
ReportingServicesService!dbpolling!d84!09/21/2005-14:39:10:
NotificationPolling finished processing ite
4105c963-0eb9-4f69-bbbc-81ab27964a4

Email subscription failing when report is included in email.

Hey All,

I am using SQL Server RS 2000 and I am running an issue. I create a subscription to email a report to a list of users. Everything works fine if I just setup the subscription so that a link to the report is to be sent in the email. But if I tell the subscription to include the report in the email, the sending of the email fails. What am I doing wrong? Is this a known issue? If so, is there a patch for it?

Thanks,

Jean

I ran into similar emailing issues a while ago when I created a data-driven subscription. I changed the RenderFormat from "Web archive" to "Web page for IE 5.0 or later" and it worked for me.