Data Alert in SharePoint 2010 does not send email - by Jayaram Krishnaswamy

Status : 

 


1
0
Sign in
to vote
ID 786377 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 5/4/2013 6:02:48 PM
Access Restriction Public

Description

Data Alerts in SharePoint Integrated mode and Data Driven subscription in Native mode do not send email  when SMTP of Gmail. Live.com are used. 
The Installation of the Reporting Services are on SQL Server 2012 and SQL Server 2012 with RS in SharePoint Integrated mode.

SQL Server 2012 and SharePoint 2010 both enterprise evaluation.
The computer box is a laptop using Windows 7 Ultimate (x64bit).

Simple reports were generated using Report Builder and deployed to Native Mode Report Server or to SharePoint site documents' folder where RS type documents types were enabled.
Send alerts by email failed.

The outlook.com account configured and using the SMTP.live.com properly configured to send emails from a 'FROM" account were never sent.
The error is usually the following:


TestJetShipping    TestSP    HODENTEKWIN7\mysorian    0    5/4/2013 2:34:49 PM    5/4/2013 2:34:33 PM    Last alert failed
Details:  The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first The log file contains detailed information about the error. Refer to the log entry with the identifier: 1eab9d22-754b-4308-bd28-9323930bcd51..    

TestSP    TestSP    HODENTEKWIN7\mysorian    0    5/4/2013 10:45:51 AM    5/4/2013 10:44:36 AM    Last alert failed
Details:  The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first The log file contains detailed information about the error. Refer to the log entry with the identifier: 3124f598-be3e-4a16-a673-f07ca5cce005..    

Log entry does not provide anything beyond what is seen in this large text file(log file).

The important question that remains unanswered in the forums is: "Is it doable to use web mails SMTP for data alerts and data driven subscription?'
Sign in to post a comment.
Posted by Matt [MSFT] on 6/2/2014 at 3:16 PM
Hello,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.
Matt Jones
SSRS Tiger Dev Team
Posted by Matt [MSFT] on 5/14/2014 at 11:05 AM
Hello,

Thank you for submitting this feedback. We are investigating the issue and will update you when we have more information.

Thanks,
Matt Jones
SSRS Tiger Dev Team