i tried suggested here, ssrs still returns error.
failure sending mail: transport failed connect server.
for ssrs configuration, have following in config file:
<extension name="report server email" type="microsoft.reportingservices.emaildeliveryprovider.emailprovider, reportingservicesemaildeliveryprovider"> <maxretries>3</maxretries> <secondsbeforeretry>900</secondsbeforeretry> <configuration> <rsemaildpconfiguration> <smtpserver>myservername</smtpserver> <smtpserverport></smtpserverport> <smtpaccountname></smtpaccountname> <smtpconnectiontimeout></smtpconnectiontimeout> <smtpserverpickupdirectory></smtpserverpickupdirectory> <smtpusessl></smtpusessl> <sendusing>2</sendusing> <smtpauthenticate></smtpauthenticate> <from>support@mydomain.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> </configuration> </extension>
myservername name of server ssrs on it
the same e-mail used sign in remote mail server
i've tried everything, worn't work. , when use telnet send e-mail message, email sent on mail box fine. ssrs won't play nice. i'm on day 2 of dealing ssrs , emailing through remote server , don't know how more pain can handle.
edit:
here's logs failed subscription execution.
reportingservicesservice!dbpolling!3!12/20/2010-13:47:09:: eventpolling processing 1 more items. 1 total items in internal queue. reportingservicesservice!dbpolling!10!12/20/2010-13:47:09:: eventpolling processing item d154e22a-b802-434e-9825-81d8e640932a reportingservicesservice!library!10!12/20/2010-13:47:09:: schedule b39a9192-c0ce-4106-96ac-2f6edb82bfed executed @ 12/20/2010 1:47:09 pm. reportingservicesservice!schedule!10!12/20/2010-13:47:09:: creating time based subscription notification subscription: 1e8fac03-be9b-4241-a485-042e572aba27 reportingservicesservice!library!10!12/20/2010-13:47:09:: schedule b39a9192-c0ce-4106-96ac-2f6edb82bfed execution completed @ 12/20/2010 1:47:09 pm. reportingservicesservice!dbpolling!10!12/20/2010-13:47:09:: eventpolling finished processing item d154e22a-b802-434e-9825-81d8e640932a reportingservicesservice!dbpolling!3!12/20/2010-13:47:09:: notificationpolling processing 1 more items. 1 total items in internal queue. reportingservicesservice!dbpolling!10!12/20/2010-13:47:09:: notificationpolling processing item 79ab6eeb-6a19-4fdf-aea9-e35076977123 reportingservicesservice!library!10!12/20/2010-13:47:09:: info: call renderfirst( '/ftni.reports/activationemail' ) reportingservicesservice!library!10!12/20/2010-13:47:09:: info: initializing enableexecutionlogging 'true' specified in server system properties. reportingservicesservice!emailextension!10!12/20/2010-13:47:09:: error sending email. system.runtime.interopservices.comexception (0x80040213): transport failed connect server. @ reportingservicescdointerop.messageclass.send() @ microsoft.reportingservices.emaildeliveryprovider.emailprovider.deliver(notification notification) reportingservicesservice!dbpolling!10!12/20/2010-13:47:09:: notificationpolling finished processing item 79ab6eeb-6a19-4fdf-aea9-e35076977123 reportingservicesservice!dbpolling!13!12/20/2010-13:47:19:: notificationpolling processing item bd614dbb-c230-4d18-9091-5af1afb14428 reportingservicesservice!dbpolling!10!12/20/2010-13:47:19:: notificationpolling processing item 42ba3e10-44b3-4b3e-8bb4-c3371c632be8 reportingservicesservice!dbpolling!3!12/20/2010-13:47:19:: notificationpolling processing 2 more items. 2 total items in internal queue. reportingservicesservice!library!10!12/20/2010-13:47:19:: info: call renderfirst( '/ftni.reports/activationemail' ) reportingservicesservice!library!13!12/20/2010-13:47:19:: info: call renderfirst( '/ftni.reports/activationemail' ) reportingservicesservice!library!13!12/20/2010-13:47:20:: info: initializing enableexecutionlogging 'true' specified in server system properties. reportingservicesservice!library!10!12/20/2010-13:47:20:: info: initializing enableexecutionlogging 'true' specified in server system properties. reportingservicesservice!emailextension!13!12/20/2010-13:47:20:: error sending email. system.runtime.interopservices.comexception (0x80040213): transport failed connect server. @ reportingservicescdointerop.messageclass.send() @ microsoft.reportingservices.emaildeliveryprovider.emailprovider.deliver(notification notification) reportingservicesservice!dbpolling!13!12/20/2010-13:47:20:: notificationpolling finished processing item bd614dbb-c230-4d18-9091-5af1afb14428 reportingservicesservice!emailextension!10!12/20/2010-13:47:20:: error sending email. system.runtime.interopservices.comexception (0x80040213): transport failed connect server. @ reportingservicescdointerop.messageclass.send() @ microsoft.reportingservices.emaildeliveryprovider.emailprovider.deliver(notification notification) reportingservicesservice!dbpolling!10!12/20/2010-13:47:20:: notificationpolling finished processing item 42ba3e10-44b3-4b3e-8bb4-c3371c632be8 reportingservicesservice!dbpolling!a!12/20/2010-13:47:21:: eventpolling polling service stopped reportingservicesservice!dbpolling!e!12/20/2010-13:47:21:: eventpolling heartbeat thread exiting stop. reportingservicesservice!dbpolling!a!12/20/2010-13:47:21:: notificationpolling polling service stopped reportingservicesservice!dbpolling!8!12/20/2010-13:47:21:: notificationpolling heartbeat thread exiting stop. reportingservicesservice!dbpolling!a!12/20/2010-13:47:21:: schedulepolling polling service stopped reportingservicesservice!dbpolling!a!12/20/2010-13:47:21:: upgradepolling polling service stopped reportingservicesservice!servicecontroller!a!12/20/2010-13:47:22:: service controller exiting.
Comments
Post a Comment