SSRS E mail Delivery Problem
Dear All,
I have a Problem in SSRS E mail Timed Subscriptions the emails are not sent to destinations but i can view the message in Mysubscription list as like "Your mail sent to
myaccount@yahoo.com successfully". The mails are sent to Bad mail folder so i could not get mails in
myaccounts@yahoo.com. exept gmail account mails i can recive my mymail at
myaccount@gmail.com but here is one more problem that is most of the report mals consider as spam mails.
This is my email configuration SMTP server: smtp.bizmail.yahoo.com ; Delivery method: Send to local pickup directory ; Sender Address:
useraccount@yahoo.com My SMTP Server are working fine for Outlookexpress, i am also received my ssrs reports only my gmail accounts.
I could not found no error message in report server log files. My badmail folder have some error messages .BDR : Unable to deliver this message because the follow error was encountered: "This message is a delivery status notification that cannot be delivered.".The specific error code was 0xC00402C7.The message sender
was <>.The message was intended for the following recipients. myaccounts@yahoo.com.
Error message .BAD:From: postmaster@Systemname.Domain.COM
To: myaccounts@yahoo.com.
Date: Fri, 23 Jul 2010 20:26:38 +0530
MIME-Version: 1.0
Content-Type: multipart/report; report-type=delivery-status;
boundary="9B095B5ADSN=_01CB2A6E96CFBA1A000000A8Director.USHAFIR"
X-DSNContext: 7ce717b1 - 1386 - 00000002 - C00402D1
Message-ID: <l3xbYiMCI00000031@Username.Domain.COM>
Subject: Delivery Status Notification (Failure)
This is a MIME-formatted message.
Portions of this message may be unreadable without a MIME-capable mail program.
--9B095B5ADSN=_01CB2A6E96CFBA1A000000A8Director.USHAFIR
Content-Type: text/plain; charset=unicode-1-1-utf-7
This is an automatically generated Delivery Status Notification.
Unable to deliver message to the following recipients, due to being unable to connect successfully to the destination mail server.
myaccount@rediffmail.com
--9B095B5ADSN=_01CB2A6E96CFBA1A000000A8Director.USHAFIR
Content-Type: message/delivery-status
Reporting-MTA: dns;Username.Domain.COM
Received-From-MTA: dns;Systemname.Domain.COM
Arrival-Date: Wed, 21 Jul 2010 19:35:08 +0530
Final-Recipient: rfc822;myaccount@rediffmail.com
Action: failed
Status: 4.4.7
--9B095B5ADSN=_01CB2A6E96CFBA1A000000A8Director.USHAFIR
Content-Type: message/rfc822
Received: from mail pickup service by
Systemname.Domain.COM with Microsoft SMTPSVC;
Wed, 21 Jul 2010 19:35:08 +0530
Thread-Topic: Test Report for Email was executed at 21/07/2010 7:35:08 PM
thread-index: Acso3bnUuh6DxIiwROudyrzN78aZZg==
Reply-To:
From: <myaccounts@yahoo.com.>
To: <myaccounts2@yahoo.com.>
Cc: <myaccounts3@yahoo.com.>,
<myaccount@rediffmail.com>
Subject: Test Report for Email was executed at 21/07/2010 7:35:08 PM
Date: Wed, 21 Jul 2010 19:35:08 +0530
Message-ID: <12044A81A5374C5FA3FC6C44F5B3973E@USHAFIRE.COM>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_02A4_01CB290B.D39AD5B0"
X-Mailer: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4657
X-OriginalArrivalTime: 21 Jul 2010 14:05:08.0375 (UTC) FILETIME=[BA01BA70:01CB28DD]
This is a multi-part message in MIME format.
------=_NextPart_000_02A4_01CB290B.D39AD5B0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: 7bit
Related sugessions are welcome,
Thanks in advance,
Vasantha Prabakaran.T
July 23rd, 2010 6:42pm
Hi Vasantha,
It seemed that you have no an existing remote SMTP server. If so, you should switch to using a local SMTP service. See
http://technet.microsoft.com/en-us/library/ms159155.aspx for more information about this. Read and follow
http://technet.microsoft.com/en-us/library/ms345234.aspx for how to configure a local SMTP for the report server.
Hope this helpfully,
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2010 11:42am
Dear Jerry,
Thanks for u r valuable Reply.I am tried different combinations using remote SMTP as well as local SMTP services. But i could not get expected results but i have alittle improvement that ie now the emails can reaches to rediffmail and gmail
accounts with some late comming mails but yahoo account are not received the mails. (Note: Firewalls are disbled)
pls give any sugessions.
Thanks
Vasantha Prabakaran.T
July 28th, 2010 12:49pm
Hi Vasantha,
I am facing ____ lot of issues in SSRS mailing functionality. Can you please explain me at
ravishankar.net3.5@gmail.com.
my questions are
does the service acc or execution acc has anything to do? i faced two errors "email address is not valid" for the send email eror is "access denied" for the save to pickup directory
i am in big trouble.
please help me.
thnx in advance....
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2010 2:09am
never mind.....i have done it
August 20th, 2010 2:30pm
Hopefully this will get to you now that it is about a year later. SSRS on SQL05 sends out email to many people in our company and has been doing that for at least a year and very successfully. All of a sudden on 6/29/2011 all emails are going
to the recipents Junk folder in their Outlook. My network admin people say nothing has been changed on the servers. All the mail currently is on the same network as the email and SQL server.
I was told this was not the correct forum for this kind of a problem but I see it at least used to be.
JayJay Nichols
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2011 12:09pm