失败编写文件log_file_risk_alert_report:授予用户的权限''不足以执行此操作
上下文:当我尝试执行SSRS电子邮件或文件删除订阅时,我会不断提出此错误 - 我不知道为什么。空字符串''
似乎意味着我需要添加一些特定的用户信息,但我不知道在哪里。
我能够通过管理工作室的数据库邮件向导发送测试电子邮件。我在SQL Server sysmail_event_log
记录该事件的记录last_mod_user
是ntservice \ mssqlserver
。但是失败的订阅执行尝试在sa
下显示在last_mod_user
中,我怀疑我怀疑这种差异之间有些事情在起作用,但是IDK如何修复它。
错误描述还读取:
由于邮件,邮件无法发送给收件人 服务器故障。 (使用帐户4(2022-04-22T17:41:01)发送邮件。 异常消息:无法将邮件发送到邮件服务器。 (SMTP服务器 需要安全的连接或未经认证的客户端。这 服务器响应是:5.7.57客户端未经身份验证以发送邮件。 [bn0p110ca0026.namp110.prod.outlook.com])。 )
问题:有人可以协助吗?
Context: I keep raising this error when I try to execute an SSRS Email or File Drop subscription - and I have no idea why. The empty string ''
seems to imply I need to add some specific user information but I have no idea where.
I was able to send a test email through the Database Mail wizard in the management studio. I noticed in the SQL Server sysmail_event_log
record for that event the last_mod_user
was NTService\MSSQLSERVER
. But the failed subscription execution attempts are showing up under the sa
in the last_mod_user
I suspect something is at play between this discrepancy but idk how to fix it.
The error description also reads:
The mail could not be sent to the recipients because of the mail
server failure. (Sending Mail using Account 4 (2022-04-22T17:41:01).
Exception Message: Cannot send mails to mail server. (The SMTP server
requires a secure connection or the client was not authenticated. The
server response was: 5.7.57 Client not authenticated to send mail.
[BN0P110CA0026.NAMP110.PROD.OUTLOOK.COM]). )
Questions: Can someone please assist?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
将帐户添加到计算机的本地管理员以修复操作。
Add the account to the Local Admin of the Machine to fix the Operation.Mail one