I've a SQL Reporting ith this RSReportServer.config :
<RSEmailDPConfiguration>
<SMTPServer>172.25.1.59</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>intranet@.mycompany.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>
But when I make a new mail Subscriptions, don't working:
Failure sending mail: The transport failed to connect to the
server.
And the log file give me this:
ReportingServicesService!library!1064!11/02/2004-17:57:15:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1064!11/02/2004-17:57:15:: Error
sending email. System.Runtime.InteropServices.COMException (0x80040213): The
transport failed to connect to the server.
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!dbpolling!1064!11/02/2004-17:57:15::
NotificationPolling finished processing item
91401e2a-9b75-4ece-9168-92dd6b39defb
The smpt server it's ok, it's smtp server of my company and the From account
it's ok, I can send mails with this account.
Help, please
--
Sorry for my English :)I have had this problem and not sure why. The server was hosted by our IT
team and the SMTP service was installed on the machine but did not seem to be
running at the time. To get around this I redirected the email request to
use our corporate SMTP server...
<SMTPServer>smtp.mycompanydomain</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SendUsing>2</SendUsing>
Where mycompanydomain could be yahoo.com, microsoft.com or whatever your
intranet domain is. The usual default SMTP port is 25 and the send using
parameter specifies whether to use the network pickup directory of SMTP
server (SendUsing=2) or the local specified pickup folder in the
<SMTPServerPickupDirectory></SMTPServerPickupDirectory> tag (SendUsing=1).
Can also try this MS link if still having questions or problems..
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
"Juan Carlos" wrote:
> I've a SQL Reporting ith this RSReportServer.config :
> <RSEmailDPConfiguration>
> <SMTPServer>172.25.1.59</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>intranet@.mycompany.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>
> But when I make a new mail Subscriptions, don't working:
> Failure sending mail: The transport failed to connect to the
> server.
> And the log file give me this:
> ReportingServicesService!library!1064!11/02/2004-17:57:15:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server system
> properties.
> ReportingServicesService!emailextension!1064!11/02/2004-17:57:15:: Error
> sending email. System.Runtime.InteropServices.COMException (0x80040213): The
> transport failed to connect to the server.
> at ReportingServicesCDOInterop.MessageClass.Send()
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> ReportingServicesService!dbpolling!1064!11/02/2004-17:57:15::
> NotificationPolling finished processing item
> 91401e2a-9b75-4ece-9168-92dd6b39defb
> The smpt server it's ok, it's smtp server of my company and the From account
> it's ok, I can send mails with this account.
> Help, please
> --
> Sorry for my English :)|||Sorry Chad, but doesn't work.
I changed the configuration and doesn't work. Now I've this log file:
ReportingServicesService!dbpolling!944!11/03/2004-10:48:45::
NotificationPolling finished processing item
583d1bf1-60d9-48ea-9378-67c5fca192a2
ReportingServicesService!library!93c!11/03/2004-10:48:45:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!session!93c!11/03/2004-10:48:45:: i INFO:
LoadSnapshot: Item with session: ik22fp3hkxlaj3ydmvreb5fq, reportPath:
/ReportFolder01/Globales2, userName: MyCompanyDomain\myUserName not found in
the database
ReportingServicesService!chunks!93c!11/03/2004-10:48:45:: i INFO: ###
GetReportChunk('Globales2_style', 1), chunk was not found!
this=f1b65dc6-6090-4f90-a50e-10ed1cf2077a
ReportingServicesService!emailextension!93c!11/03/2004-10:48:46:: Error
sending email. System.Runtime.InteropServices.COMException (0x80040213): The
transport failed to connect to the server.
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!93c!11/03/2004-10:48:46:: Notification
da1ad789-d3fe-4e7c-9848-6a9f1590aec6 completed. Success: False, Status:
Failure sending mail: The transport failed to connect to the server.
, DeliveryExtension: Report Server Email, Report: Globales2, Attempt 4
ReportingServicesService!dbpolling!93c!11/03/2004-10:48:46::
NotificationPolling finished processing item
da1ad789-d3fe-4e7c-9848-6a9f1590aec6
ReportingServicesService!dbpolling!938!11/3/2004-10:49:10:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!990!11/03/2004-10:49:10:: EventPolling
processing item c5caac87-8610-42fd-9263-e81ccb00665a
ReportingServicesService!schedule!990!11/03/2004-10:49:10:: w WARN: An event
schedule fired that does not exists in the report server database
ReportingServicesService!dbpolling!990!11/03/2004-10:49:10:: EventPolling
finished processing item c5caac87-8610-42fd-9263-e81ccb00665a
I need help... :(
"Chad P." wrote:
> I have had this problem and not sure why. The server was hosted by our IT
> team and the SMTP service was installed on the machine but did not seem to be
> running at the time. To get around this I redirected the email request to
> use our corporate SMTP server...
> <SMTPServer>smtp.mycompanydomain</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SendUsing>2</SendUsing>
> Where mycompanydomain could be yahoo.com, microsoft.com or whatever your
> intranet domain is. The usual default SMTP port is 25 and the send using
> parameter specifies whether to use the network pickup directory of SMTP
> server (SendUsing=2) or the local specified pickup folder in the
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory> tag (SendUsing=1).
> Can also try this MS link if still having questions or problems...
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
>
> "Juan Carlos" wrote:
> > I've a SQL Reporting ith this RSReportServer.config :
> >
> > <RSEmailDPConfiguration>
> > <SMTPServer>172.25.1.59</SMTPServer>
> > <SMTPServerPort></SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate></SMTPAuthenticate>
> > <From>intranet@.mycompany.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>
> >
> > But when I make a new mail Subscriptions, don't working:
> > Failure sending mail: The transport failed to connect to the
> > server.
> >
> > And the log file give me this:
> >
> > ReportingServicesService!library!1064!11/02/2004-17:57:15:: i INFO:
> > Initializing EnableExecutionLogging to 'True' as specified in Server system
> > properties.
> >
> > ReportingServicesService!emailextension!1064!11/02/2004-17:57:15:: Error
> > sending email. System.Runtime.InteropServices.COMException (0x80040213): The
> > transport failed to connect to the server.
> >
> > at ReportingServicesCDOInterop.MessageClass.Send()
> > at
> > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> >
> > ReportingServicesService!dbpolling!1064!11/02/2004-17:57:15::
> > NotificationPolling finished processing item
> > 91401e2a-9b75-4ece-9168-92dd6b39defb
> >
> > The smpt server it's ok, it's smtp server of my company and the From account
> > it's ok, I can send mails with this account.
> >
> > Help, please
> >
> > --
> > Sorry for my English :)|||try to also add in the pickup directory in the config file:
<SMTPServerPickupDirectory>C:\Inetpub\mailroot\Pickup</SMTPServerPickupDirectory>
Just search for the folder 'pickup' in C: and paste it as above.
Also, make sure you SMTPServer IP address is correct in the
reportserver.config file.
Hope this works for you - worked for me.
TdP
"Juan Carlos" wrote:
> Sorry Chad, but doesn't work.
> I changed the configuration and doesn't work. Now I've this log file:
> ReportingServicesService!dbpolling!944!11/03/2004-10:48:45::
> NotificationPolling finished processing item
> 583d1bf1-60d9-48ea-9378-67c5fca192a2
> ReportingServicesService!library!93c!11/03/2004-10:48:45:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server system
> properties.
> ReportingServicesService!session!93c!11/03/2004-10:48:45:: i INFO:
> LoadSnapshot: Item with session: ik22fp3hkxlaj3ydmvreb5fq, reportPath:
> /ReportFolder01/Globales2, userName: MyCompanyDomain\myUserName not found in
> the database
> ReportingServicesService!chunks!93c!11/03/2004-10:48:45:: i INFO: ###
> GetReportChunk('Globales2_style', 1), chunk was not found!
> this=f1b65dc6-6090-4f90-a50e-10ed1cf2077a
> ReportingServicesService!emailextension!93c!11/03/2004-10:48:46:: Error
> sending email. System.Runtime.InteropServices.COMException (0x80040213): The
> transport failed to connect to the server.
> at ReportingServicesCDOInterop.MessageClass.Send()
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> ReportingServicesService!notification!93c!11/03/2004-10:48:46:: Notification
> da1ad789-d3fe-4e7c-9848-6a9f1590aec6 completed. Success: False, Status:
> Failure sending mail: The transport failed to connect to the server.
> , DeliveryExtension: Report Server Email, Report: Globales2, Attempt 4
> ReportingServicesService!dbpolling!93c!11/03/2004-10:48:46::
> NotificationPolling finished processing item
> da1ad789-d3fe-4e7c-9848-6a9f1590aec6
> ReportingServicesService!dbpolling!938!11/3/2004-10:49:10:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!990!11/03/2004-10:49:10:: EventPolling
> processing item c5caac87-8610-42fd-9263-e81ccb00665a
> ReportingServicesService!schedule!990!11/03/2004-10:49:10:: w WARN: An event
> schedule fired that does not exists in the report server database
> ReportingServicesService!dbpolling!990!11/03/2004-10:49:10:: EventPolling
> finished processing item c5caac87-8610-42fd-9263-e81ccb00665a
> I need help... :(
>
> "Chad P." wrote:
> > I have had this problem and not sure why. The server was hosted by our IT
> > team and the SMTP service was installed on the machine but did not seem to be
> > running at the time. To get around this I redirected the email request to
> > use our corporate SMTP server...
> > <SMTPServer>smtp.mycompanydomain</SMTPServer>
> > <SMTPServerPort>25</SMTPServerPort>
> > <SendUsing>2</SendUsing>
> >
> > Where mycompanydomain could be yahoo.com, microsoft.com or whatever your
> > intranet domain is. The usual default SMTP port is 25 and the send using
> > parameter specifies whether to use the network pickup directory of SMTP
> > server (SendUsing=2) or the local specified pickup folder in the
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory> tag (SendUsing=1).
> >
> > Can also try this MS link if still having questions or problems...
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp
> >
> >
> > "Juan Carlos" wrote:
> >
> > > I've a SQL Reporting ith this RSReportServer.config :
> > >
> > > <RSEmailDPConfiguration>
> > > <SMTPServer>172.25.1.59</SMTPServer>
> > > <SMTPServerPort></SMTPServerPort>
> > > <SMTPAccountName></SMTPAccountName>
> > > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > > <SMTPUseSSL></SMTPUseSSL>
> > > <SendUsing></SendUsing>
> > > <SMTPAuthenticate></SMTPAuthenticate>
> > > <From>intranet@.mycompany.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>
> > >
> > > But when I make a new mail Subscriptions, don't working:
> > > Failure sending mail: The transport failed to connect to the
> > > server.
> > >
> > > And the log file give me this:
> > >
> > > ReportingServicesService!library!1064!11/02/2004-17:57:15:: i INFO:
> > > Initializing EnableExecutionLogging to 'True' as specified in Server system
> > > properties.
> > >
> > > ReportingServicesService!emailextension!1064!11/02/2004-17:57:15:: Error
> > > sending email. System.Runtime.InteropServices.COMException (0x80040213): The
> > > transport failed to connect to the server.
> > >
> > > at ReportingServicesCDOInterop.MessageClass.Send()
> > > at
> > > Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> > >
> > > ReportingServicesService!dbpolling!1064!11/02/2004-17:57:15::
> > > NotificationPolling finished processing item
> > > 91401e2a-9b75-4ece-9168-92dd6b39defb
> > >
> > > The smpt server it's ok, it's smtp server of my company and the From account
> > > it's ok, I can send mails with this account.
> > >
> > > Help, please
> > >
> > > --
> > > Sorry for my English :)
Friday, February 17, 2012
Error sending mail
Labels:
59lt,
config,
database,
error,
ith,
ltrsemaildpconfigurationgt,
ltsmtpservergt172,
mail,
microsoft,
mysql,
oracle,
reporting,
rsreportserver,
sending,
server,
smtpservergt,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment