使用Reporting Service订阅对域外用户发邮件
来源:互联网 发布:matlab 遍历数组 编辑:程序博客网 时间:2024/06/07 09:22
默认情况下使用Reporting Service对域外邮件发送会失败,一般可能会碰到下面的两个错误:
ERROR 1:
Subscription Error: "The e-mail address of one or more recipients is not valid."
This error usually occurs when the SMTP server is not configured for "email relay". SMTP relay between the Reporting Services server and the SMTP server should be enabled.
ERROR 2:
Failure sending mail: The server rejected the sender address. The server response was: 550 5.7.1 Client does not have permissions to send as this sender
解决办法:
With authentication:
- Configure the option <SMTPAuthenticate> to 2 in the rsreportserver.config
file to specify that the report server connects to the remote SMTP server in an
authenticated way. More info:
Configuring a Report Server for E-Mail Delivery
http://msdn.microsoft.com/en-gb/library/ms159155(v=sql.105).aspx
2. If you want to configure the relay authenticated, you need to give “Send As” permissions Reporting Services account in the SMTP server. “Send As” allows one user to send an email as though it came from another user. More info:
How to Manually Grant Send As Permissions to a User with Full Mailbox Access
http://technet.microsoft.com/en-us/library/bb125118(EXCHG.65).aspx
Anonymous:
- Configure the option <SMTPAuthenticate> to 0. More info:
Configuring a Report Server for E-Mail Delivery
http://msdn.microsoft.com/en-gb/library/ms159155(v=sql.105).aspx
2. Create a receive connector to accept the anonymous relay and add the IP of the Reporting Services machine to the list of IPs of the connector.
配置完成后可以正常发送邮件了。
顺便吐槽一下微软的SSRS的配置界面,在Database Mail配置的过程中有很多选项可以供选择,比如使用哪种认证方式,但是在SSRS的配置界面中就一个发送账户和SMTP Server,难道不能也像DB Mail那样配置嘛?非得要去修改Config 文件。
- 使用Reporting Service订阅对域外用户发邮件
- 使用Reporting Service邮件订阅问题
- Reporting Service电子邮件订阅
- 配置Reporting Service以发送邮件
- SQL Server Reporting Services一步步实现邮件订阅
- 配置SQL Server 2005 Reporting Service 的订阅功能
- 配置SQL Server 2005 Reporting Service 的订阅功能
- Reporting Service 2005 使用技巧
- Reporting Service 中的函数使用
- 如何科学增长邮件订阅用户?
- jMAIL使用,发邮件
- 使用ruby发邮件
- 使用python发邮件
- 使用oracle发邮件
- 使用sendmail 发邮件
- 使用SES发邮件
- 使用Blat发邮件
- 使用python 发邮件
- Myeclipse中部署项目,查看部署进度、服务器端口号
- win7系统下安装SQL Server 2005
- 排序算法性能比较
- 我总结的EXCEL经典用法全集
- C#实现POST提交方式
- 使用Reporting Service订阅对域外用户发邮件
- mysql查询ID排序问题,
- Android在listview添加checkbox实现单选多选操作问题
- 下班倒计时
- Greenplum朝花夕拾 之 神奇的列存储
- poj 1485 Fast Food
- FFMPEG的一些使用技巧
- Oracle the password has expired -密码过期
- iOS开发之OAuth 授权的实现方式