emailsubscription - eventpolling, but no notificationpolling

Hi,
>From script i'm sending a few emails with pdf attachments.
One report is mailed, two others not. The script for creating the
subscriptions is equal, only different parameters.
When I look in the logfiles I don't see any errors, however only the
succeeded report has both event- and notificationpolling logging.
So the logging for the succeeded one is:
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:52::
EventPolling processing item f21fb887-9e00-40c5-8fac-f246ad14bd4f
ReportingServicesService!dbpolling!194!30.04.2005-05:49:52::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
3461442c-d51f-4701-9413-a5bef0d283a0 executed at 04/30/2005 05:49:53.
ReportingServicesService!schedule!1240!04/30/2005-05:49:53:: Creating
Time based subscription notification for subscription:
3424547a-9e5a-4e74-8bd1-78af62a38490
ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
3461442c-d51f-4701-9413-a5bef0d283a0 execution completed at 04/30/2005
05:49:53.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling finished processing item
f21fb887-9e00-40c5-8fac-f246ad14bd4f
ReportingServicesService!dbpolling!194!30.04.2005-05:49:53::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling processing item 351c51cd-2274-4218-b92e-f05ebdcc0bcb
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
EventPolling finished processing item
351c51cd-2274-4218-b92e-f05ebdcc0bcb
ReportingServicesService!dbpolling!194!30.04.2005-05:49:54::
NotificationPolling processing 1 more items. 1 Total items in internal
queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:54::
NotificationPolling processing item
72b719c2-1ae2-4e7a-a096-b15364e8ebd4
ReportingServicesService!library!1240!04/30/2005-05:49:55:: i INFO:
Call to RenderFirst( '/KEAS/KEASReports/Analyse' )
ReportingServicesService!library!1240!04/30/2005-05:49:56:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server
system properties.
ReportingServicesService!emailextension!1240!04/30/2005-05:49:57::
Email successfully sent to "spitz@.tiscali.nl" <spitz@.tiscali.nl>
ReportingServicesService!library!1240!04/30/2005-05:49:57:: Data Driven
Notification for activation id eff41ff5-c76d-4ced-be63-377e82daf4bb was
saved.
ReportingServicesService!library!1240!04/30/2005-05:49:57:: Status:
Mail sent to spitz@.tiscali.nl;
ReportingServicesService!notification!1240!04/30/2005-05:49:57::
Notification 72b719c2-1ae2-4e7a-a096-b15364e8ebd4 completed. Success:
True, Status: Mail sent to spitz@.tiscali.nl;, DeliveryExtension: Report
Server Email, Report: Analyse, Attempt 0
ReportingServicesService!dbpolling!1240!04/30/2005-05:49:57::
NotificationPolling finished processing item
72b719c2-1ae2-4e7a-a096-b15364e8ebd4
The logging for the ones that are not mailed (the subscriptions are
created):
ReportingServicesService!dbpolling!194!30.04.2005-05:48:52::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:52::
EventPolling processing item a3d3a5e0-4634-4f32-ab10-8564fa09be40
ReportingServicesService!library!1240!04/30/2005-05:48:52:: Schedule
54043fb7-5eec-4063-ae6e-a0ed054e538c executed at 04/30/2005 05:48:52.
ReportingServicesService!schedule!1240!04/30/2005-05:48:52:: Creating
Time based subscription notification for subscription:
9e5701ab-2fc5-48ab-8290-ae05f55fb29f
ReportingServicesService!library!1240!04/30/2005-05:48:53:: Schedule
54043fb7-5eec-4063-ae6e-a0ed054e538c execution completed at 04/30/2005
05:48:53.
ReportingServicesService!dbpolling!194!30.04.2005-05:48:53::
EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling finished processing item
a3d3a5e0-4634-4f32-ab10-8564fa09be40
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling processing item 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
EventPolling finished processing item
7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
The securitysettings for all reports are equal.
The failed jobs are also not mailed if started from sqlagent (although
they succeed as sqlagentjob)
Any suggestions are more than welcome, since i have no clue how to
solve this!
Regards jespHave you tried viewing the subscriptions through Report Manager? Perhaps
something is not set up correctly causing the subscription to not fire
correctly.
Have you tried creating the same subscriptions through Report Manager?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jesp" <spitz@.tiscali.nl> wrote in message
news:1115007058.978980.232660@.o13g2000cwo.googlegroups.com...
> Hi,
>>From script i'm sending a few emails with pdf attachments.
> One report is mailed, two others not. The script for creating the
> subscriptions is equal, only different parameters.
> When I look in the logfiles I don't see any errors, however only the
> succeeded report has both event- and notificationpolling logging.
> So the logging for the succeeded one is:
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:52::
> EventPolling processing item f21fb887-9e00-40c5-8fac-f246ad14bd4f
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:52::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
> 3461442c-d51f-4701-9413-a5bef0d283a0 executed at 04/30/2005 05:49:53.
> ReportingServicesService!schedule!1240!04/30/2005-05:49:53:: Creating
> Time based subscription notification for subscription:
> 3424547a-9e5a-4e74-8bd1-78af62a38490
> ReportingServicesService!library!1240!04/30/2005-05:49:53:: Schedule
> 3461442c-d51f-4701-9413-a5bef0d283a0 execution completed at 04/30/2005
> 05:49:53.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling finished processing item
> f21fb887-9e00-40c5-8fac-f246ad14bd4f
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:53::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling processing item 351c51cd-2274-4218-b92e-f05ebdcc0bcb
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:53::
> EventPolling finished processing item
> 351c51cd-2274-4218-b92e-f05ebdcc0bcb
> ReportingServicesService!dbpolling!194!30.04.2005-05:49:54::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:54::
> NotificationPolling processing item
> 72b719c2-1ae2-4e7a-a096-b15364e8ebd4
> ReportingServicesService!library!1240!04/30/2005-05:49:55:: i INFO:
> Call to RenderFirst( '/KEAS/KEASReports/Analyse' )
> ReportingServicesService!library!1240!04/30/2005-05:49:56:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system properties.
> ReportingServicesService!emailextension!1240!04/30/2005-05:49:57::
> Email successfully sent to "spitz@.tiscali.nl" <spitz@.tiscali.nl>
> ReportingServicesService!library!1240!04/30/2005-05:49:57:: Data Driven
> Notification for activation id eff41ff5-c76d-4ced-be63-377e82daf4bb was
> saved.
> ReportingServicesService!library!1240!04/30/2005-05:49:57:: Status:
> Mail sent to spitz@.tiscali.nl;
> ReportingServicesService!notification!1240!04/30/2005-05:49:57::
> Notification 72b719c2-1ae2-4e7a-a096-b15364e8ebd4 completed. Success:
> True, Status: Mail sent to spitz@.tiscali.nl;, DeliveryExtension: Report
> Server Email, Report: Analyse, Attempt 0
> ReportingServicesService!dbpolling!1240!04/30/2005-05:49:57::
> NotificationPolling finished processing item
> 72b719c2-1ae2-4e7a-a096-b15364e8ebd4
> The logging for the ones that are not mailed (the subscriptions are
> created):
> ReportingServicesService!dbpolling!194!30.04.2005-05:48:52::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:52::
> EventPolling processing item a3d3a5e0-4634-4f32-ab10-8564fa09be40
> ReportingServicesService!library!1240!04/30/2005-05:48:52:: Schedule
> 54043fb7-5eec-4063-ae6e-a0ed054e538c executed at 04/30/2005 05:48:52.
> ReportingServicesService!schedule!1240!04/30/2005-05:48:52:: Creating
> Time based subscription notification for subscription:
> 9e5701ab-2fc5-48ab-8290-ae05f55fb29f
> ReportingServicesService!library!1240!04/30/2005-05:48:53:: Schedule
> 54043fb7-5eec-4063-ae6e-a0ed054e538c execution completed at 04/30/2005
> 05:48:53.
> ReportingServicesService!dbpolling!194!30.04.2005-05:48:53::
> EventPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling finished processing item
> a3d3a5e0-4634-4f32-ab10-8564fa09be40
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling processing item 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
> ReportingServicesService!dbpolling!1240!04/30/2005-05:48:53::
> EventPolling finished processing item
> 7efce5e2-8cca-4e87-9ac9-f2bac7ad68ff
>
> The securitysettings for all reports are equal.
> The failed jobs are also not mailed if started from sqlagent (although
> they succeed as sqlagentjob)
> Any suggestions are more than welcome, since i have no clue how to
> solve this!
> Regards jesp
>sql

Email tracking

Hi,
is it possible to a) have a read receipt when sending out an email and b)
know when the recipient has accessed the report?
CheersHi Wal,
Its a big ask for a reporting server. Still if you want to do it. Create a
VB/VB.net application with outlook object as reference. So you will get the
read receipt as well and your application should pick up mails from the
outbox of your machine. This is available if you enable SMTP from your
machine.
Amarnath
"Wal" wrote:
> Hi,
> is it possible to a) have a read receipt when sending out an email and b)
> know when the recipient has accessed the report?
> Cheers
>

Email subscriptions: changing "from" address for different subscriptions on same s

I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription?

It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience).

Unfortunately this isn't really possible without doing some messing around. You can make a call to the RS WMI provider to change the SenderEmailAddress value, but you would have to synchronize the code making the WMI calls with the subscription times. Definitely a hack :-(.

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

Looking for an example of sending a 2005 RS report via a web page on demand.
I would need to fire it when a user clicked a button on the web form.
In the old days, in plain old ASP, we used to build an HTML formatted email
body and then fire it off using CDO. We could still do that with ASPX but
I'd much prefer to build a report in RS (more formatting and doc type options)
and then fire it off.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1On Oct 3, 1:07 pm, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Looking for an example of sending a 2005 RS report via a web page on demand.
> I would need to fire it when a user clicked a button on the web form.
> In the old days, in plain old ASP, we used to build an HTML formatted email
> body and then fire it off using CDO. We could still do that with ASPX but
> I'd much prefer to build a report in RS (more formatting and doc type options)
> and then fire it off.
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
This link should help.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
You will want to create a Proxy (Web Reference) to
ReportingService2005.asmx. Then attach the newly created file to an
email created via ASP.NET. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
Thanks for the info.
EMartinez wrote:
>> Looking for an example of sending a 2005 RS report via a web page on demand.
>> I would need to fire it when a user clicked a button on the web form.
>[quoted text clipped - 6 lines]
>> --
>> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
>This link should help.
>http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
>You will want to create a Proxy (Web Reference) to
>ReportingService2005.asmx. Then attach the newly created file to an
>email created via ASP.NET. Hope this helps.
>Regards,
>Enrique Martinez
>Sr. Software Consultant
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1|||On Oct 4, 11:04 am, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Enrique,
> Thanks for the info.
>
> EMartinez wrote:
> >> Looking for an example of sending a 2005 RS report via a web page on demand.
> >> I would need to fire it when a user clicked a button on the web form.
> >[quoted text clipped - 6 lines]
> >> --
> >> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
> >This link should help.
> >http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingser...
> >You will want to create a Proxy (Web Reference) to
> >ReportingService2005.asmx. Then attach the newly created file to an
> >email created via ASP.NET. Hope this helps.
> >Regards,
> >Enrique Martinez
> >Sr. Software Consultant
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200710/1
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

e-mail notifications

Hi!
I'm a beginner in SQL Server. Sorry in this a stupid question but I dont have a clue.

I'm sending an e-mail when a backup ends and I want to know how can I change the subject and the body text of this notifications.

Is that possible? How can I do it?

Thanx in advance!is this backup a scheduled job? is there anyway for you to know how this backup is being done? using a DTS package??|||Yes, is a scheduled job. Why? Is this a problem?
Is better to use a DTS package? I haven't worked with this before...|||You can add a step in the job that uses xp_sendmail - passing the subject/body you want.|||Originally posted by rnealejr
You can add a step in the job that uses xp_sendmail - passing the subject/body you want.

because the backup is a job it uses the SQL server agent mail system, which is different from SQL Mail. by setting up the operator to get a msg you are useing the SQL Sever Agent mail system, which is very limited. To get greater flexability you need to use SQL mail, and the only way to get access to that is to use the xp_sendmail procedure in connection with a DTS package.
Jim|||Jim,

You don't need to use a dts package - you can run xp_sendmail within a step.|||Originally posted by rnealejr
Jim,

You don't need to use a dts package - you can run xp_sendmail within a step.

Very true didnt even think about that
Jim|||THANK YOU ALL!!
I'm going to try that way. I hope this works... :-\

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

Email delivery not functional

Hello all,
I have programmed some subscriptions, containing sending EMails to different
recipients. My Problem: The delivery of the mails is functional to
Email-adresses like ...@.web.de or sth., but NOT to emails like
...@.t-online.de .
It would be nice, if anyone could help me, it´s very important. Thank you in
advanceYou may need to check the SendEmailToUserAlias and DefaultHostName elements
in the
RSReportServer.config file.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
Adrian M.
"susanne" <susanne@.discussions.microsoft.com> wrote in message
news:49CAE9E5-DDBF-4038-AEC0-261A7D4DD6C1@.microsoft.com...
> Hello all,
> I have programmed some subscriptions, containing sending EMails to
> different
> recipients. My Problem: The delivery of the mails is functional to
> Email-adresses like ...@.web.de or sth., but NOT to emails like
> ...@.t-online.de .
> It would be nice, if anyone could help me, it´s very important. Thank you
> in
> advance

Email

Do you know a tool for email sending that make authentication of user and
password in my server external smtp of my net and that she makes use of
format HTML? thanks!Since you post in a SQL Server group, I assume you want to do this from with
in SQL Server.
SQL Server 2005 has built-in support for SMTP, authentication and HTML. The
feature is called
"Database Mail".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> Do you know a tool for email sending that make authentication of user and
> password in my server external smtp of my net and that she makes use of
> format HTML? thanks!|||I use the 2000!
"Tibor Karaszi" wrote:

> Since you post in a SQL Server group, I assume you want to do this from wi
thin SQL Server.
> SQL Server 2005 has built-in support for SMTP, authentication and HTML. Th
e feature is called
> "Database Mail".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
> news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
>
>

Email

How can I implement the functionality of sending mail with the help of SP or DTS?
SubhasishOriginally posted by subhasishray
How can I implement the functionality of sending mail with the help of SP or DTS?
Subhasish

use sp_oacreate
check this link:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23614|||Check this: http://www.dbforums.com/t980725.html

Email

Do you know a tool for email sending that make authentication of user and
password in my server external smtp of my net and that she makes use of
format HTML? thanks!Since you post in a SQL Server group, I assume you want to do this from within SQL Server.
SQL Server 2005 has built-in support for SMTP, authentication and HTML. The feature is called
"Database Mail".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> Do you know a tool for email sending that make authentication of user and
> password in my server external smtp of my net and that she makes use of
> format HTML? thanks!|||I use the 2000!
"Tibor Karaszi" wrote:
> Since you post in a SQL Server group, I assume you want to do this from within SQL Server.
> SQL Server 2005 has built-in support for SMTP, authentication and HTML. The feature is called
> "Database Mail".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Diogo Guides" <DiogoGuides@.discussions.microsoft.com> wrote in message
> news:A812A9D4-0C51-4443-BF1D-3C64CB0538AC@.microsoft.com...
> > Do you know a tool for email sending that make authentication of user and
> > password in my server external smtp of my net and that she makes use of
> > format HTML? thanks!
>
>