Reporting Services因OAuth变更无法通过Office 365 SMTP发邮件求助
我们环境部署了Windows Server 2012 R2和SQL Server 2016,Reporting Services(SSRS)通过Office 365的SMTP服务器发送邮件。之前采用用户名密码的Basic认证方式一直正常,现在突然失效。推测是因为微软要求Office 365 SMTP必须使用OAuth认证,但SQL Server 2016的SSRS中没有明确的OAuth配置选项。
以下是报表日志中的错误信息:
ERROR: Error sending email. Exception: System.Net.Mail.SmtpException:
Failure sending mail. ---> System.IO.IOException: Unable to read data
from the transport connection: net_io_connectionclosed. at
System.Net.Mail.SmtpReplyReaderFactory.ProcessRead(Byte[] buffer,
Int32 offset, Int32 read, Boolean readLine) at
System.Net.Mail.SmtpReplyReaderFactory.ReadLines(SmtpReplyReader
caller, Boolean oneLine) at
System.Net.Mail.SmtpReplyReaderFactory.ReadLine(SmtpReplyReader
caller) at System.Net.Mail.CheckCommand.Send(SmtpConnection conn,
String& response) at
System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command,
MailAddress from, Boolean allowUnicode) at
System.Net.Mail.SmtpTransport.SendMail(MailAddress sender,
MailAddressCollection recipients, String deliveryNotify, Boolean
allowUnicode, SmtpFailedRecipientException& exception) at
System.Net.Mail.SmtpClient.Send(MailMessage message)
编辑说明:抱歉,之前提供的错误信息有误。
请问有没有人遇到过SSRS邮件发送的这类问题?有没有可行的解决方案?
内容的提问来源于stack exchange,提问作者Kelly Jayne Anderson-McConnell

