时间戳

首页 > 解决方案 > 由于使用office 365的邮件服务器故障（SQL），邮件无法发送给收件人

sql-server - 由于使用office 365的邮件服务器故障（SQL），邮件无法发送给收件人

问题描述

我已经执行了以下操作。

EXEC msdb.dbo.sp_send_dbmail  @profile_name='Client_Messages',
                                          @from_address= 'Client Automation <messages@client-services.com>',
                                          @recipients='noufal@companynamedomain.com',
                                          @subject='This is a Test mail',
                                          @body='This is a Test mail from Test DB server',@body_format='html';

得到错误。有时它有效，即；邮件成功执行。有时发生错误。错误信息如下。

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2021-10-23T17:26:05). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 12.18.126.228:587).

标签： sql-serversqlmail

解决方案

推荐阅读