blocks|key|4304682|text|据我所读，听起来您可能需要设置本地SMTP中继服务器来发送电子邮件，b/c+SSRS要求“报表服务器服务必须具有SMTP服务器上的发送权限”，并且似乎没有为输入密码提供任何选项。我假设SSRS订阅电子邮件设置只使用Windows身份验证，因为它使用的是SSRS服务，但是配置文档很模糊。(http://technet.microsoft.com/en-us/library/ms345234(v=sql.105).aspx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4304683|下面是一个显示如何设置SMTP中继服务器http://www.vsysad.com/2012/04/setup-and-configure-smtp-server-on-windows-server-2008-r2/的链接|4304684|以下是您需要进行不同操作的步骤。|4304685|项目19，选择基本身份验证，输入您的gmail帐户信息，并确保TLS加密检查。|unordered-list-item|4304686|项目21，输入您的服务器名作为完全限定的域名.输入"smtp.google.com“作为”智能主机“。|style|BOLD|4304687|4304688|4304689|然后在SSRS+SMTP配置中指定上面创建的SMTP服务器。|4304690|您可能还需要启用POP3在您的gmail帐户，如果您还没有。https://support.google.com/mail/answer/13273?cbid=wl8yzeug2lob&src=cb&lev=topic|4304691|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/library/ms345234(v=sql.105%2529.aspx)|1|http://www.vsysad.com/2012/04/setup-and-configure-smtp-server-on-windows-server-2008-r2/|2|https://support.google.com/mail/answer/13273?cbid=wl8yzeug2lob&src=cb&lev=topic^0|40|1V|0|0|K|2G|1|0|0|0|7|2|0|0|0|0|U|27|2|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@$A|17|B|18|1|19]]|C|$]]|$1|D|3|E|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|F|3|G|5|6|7|1E|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|1F|8|@]|9|@]|C|$]]|$1|K|3|L|5|J|7|1G|8|@$A|1H|B|1I|M|N]]|9|@]|C|$]]|$1|O|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1K|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|1L|8|@]|9|@]|C|$]]|$1|S|3|T|5|6|7|1M|8|@]|9|@$A|1N|B|1O|1|1P]]|C|$]]|$1|U|3|-4|5|6|7|1Q|8|@]|9|@]|C|$]]]|V|$W|$5|X|Y|Z|C|$10|11]]|12|$5|X|Y|Z|C|$10|13]]|14|$5|X|Y|Z|C|$10|15]]]]

From what I have read, it sounds like you might have to setup a local SMTP relay server that you send the email through, b/c SSRS requires that "The Report Server service must have Send As permissions on the SMTP server" and does not appear to give any options for entering a password. I am assuming the SSRS subscription email setup only works using Windows authentication since it uses the SSRS Service, but the configuration documentation is vague. (<a href="http://technet.microsoft.com/en-us/library/ms345234(v=sql.105).aspx" rel="nofollow">http://technet.microsoft.com/en-us/library/ms345234(v=sql.105).aspx</a> ) 

Here is a link that shows how to setup the SMTP relay server <a href="http://www.vsysad.com/2012/04/setup-and-configure-smtp-server-on-windows-server-2008-r2/" rel="nofollow">http://www.vsysad.com/2012/04/setup-and-configure-smtp-server-on-windows-server-2008-r2/</a>

Here are the steps you'll need to do differently. 

<ul>
<li>Item 19, choose Basic Authentication, enter your gmail account info, and make sure TLS encryption is checked.</li>
<li>Item 21, enter your server name as the Fully-qualiified domain name. Enter "smtp.google.com" as the "Smart host".</li>
</ul>

Then specify the SMTP server you just created above in your SSRS SMTP configuration.

You probably also need to enable POP3 on your gmail account if you have not already. <a href="https://support.google.com/mail/answer/13273?cbid=wl8yzeug2lob&amp;src=cb&amp;lev=topic" rel="nofollow">https://support.google.com/mail/answer/13273?cbid=wl8yzeug2lob&amp;src=cb&amp;lev=topic</a>

blocks|key|2708831|text|在过去几个小时里，我一直在努力解决这个问题，我认为，对于那些仍然无法配置SSRS实例、通过gmail使用smtp中继服务发送订阅邮件的其他人来说，共享另一种方法可能是有价值的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2708832|在这个例子中，我的公司使用Gmail服务器来承载我们自己的域，我假设您可以访问Google上的管理控制台。|2708833|步骤1-配置Gmail|offset|length|style|BOLD|2708834|使用管理员帐户登录Google|unordered-list-item|2708835|进入管理控制台|2708836|选择Apps+>+Gmail+>高级设置|2708837|查找SMTP中继服务|2708838|增加新的|2708839|​|2708840|允许发送者-设置为“仅在我的域中的地址”|ordered-list-item|2708841|2708842|2708843|2708844|2708845|2708846|2708847|身份验证--设置为“只接受来自指定IP的邮件”|2708848|2708849|2708850|2708851|2708852|2708853|2708854|添加正在运行的服务器SSRS的公共IP范围|2708855|2708856|2708857|2708858|2708859|2708860|2708861|不检查TLS加密|2708862|2708863|2708864|2708865|2708866|2708867|2708868|不检查SMTP身份验证|2708869|2708870|2708871|2708872|2708873|2708874|2708875|保存|2708876|2708877|2708878|2708879|2708880|2708881|然后，您应该设置如下所示：|2708882|允许发送者:仅限于我域中的地址|2708883|只接受来自指定IP地址的邮件:是的|2708884|允许的IP地址：(您的描述)|2708885|要求SMTP身份验证:否|2708886|要求TLS加密:否|2708887|2708888|2708889|步骤2-配置SSRS|2708890|转到SSRS配置管理器>电子邮件设置|2708891|输入发件人地址为email@yourgmaildomain.co.uk|2708892|使用SMTP服务器|2708893|SMTP+Server+=+"smtp-relay.gmail.com“|2708894|2708895|2708896|按照这些步骤，您可以使用SSRS订阅发送电子邮件，而无需设置自己的中继服务器。希望这能帮助其他可怜的鞋底花上几个小时的时间来解决这个问题！|2708897|参考文献：https://support.google.com/a/answer/2956491?vid=1-635782669150538047-3380580329|2708898|entityMap|0|LINK|mutability|MUTABLE|url|https://support.google.com/a/answer/2956491?vid=1-635782669150538047-3380580329^0|0|0|0|B|0|0|0|0|0|0|1|1|1|0|0|0|0|1|1|1|0|0|0|0|1|1|1|0|0|0|0|1|1|1|0|0|0|0|1|1|1|0|0|0|0|1|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|A|0|0|0|0|0|0|0|0|5|27|0|0^^$0|@$1|2|3|4|5|6|7|3A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|3B|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|3C|8|@$F|3D|G|3E|H|I]]|9|@]|A|$]]|$1|J|3|K|5|L|7|3F|8|@]|9|@]|A|$]]|$1|M|3|N|5|L|7|3G|8|@]|9|@]|A|$]]|$1|O|3|P|5|L|7|3H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|3I|8|@]|9|@]|A|$]]|$1|S|3|T|5|L|7|3J|8|@]|9|@]|A|$]]|$1|U|3|V|5|L|7|3K|8|@]|9|@]|A|$]]|$1|W|3|X|5|Y|7|3L|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|3M|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|3N|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|3O|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|3P|8|@]|9|@]|A|$]]|$1|13|3|V|5|6|7|3Q|8|@]|9|@]|A|$]]|$1|14|3|V|5|L|7|3R|8|@]|9|@]|A|$]]|$1|15|3|16|5|Y|7|3S|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|3T|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|3U|8|@]|9|@]|A|$]]|$1|19|3|-4|5|6|7|3V|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|3W|8|@]|9|@]|A|$]]|$1|1B|3|V|5|6|7|3X|8|@]|9|@]|A|$]]|$1|1C|3|V|5|L|7|3Y|8|@]|9|@]|A|$]]|$1|1D|3|1E|5|Y|7|3Z|8|@]|9|@]|A|$]]|$1|1F|3|-4|5|6|7|40|8|@]|9|@]|A|$]]|$1|1G|3|-4|5|6|7|41|8|@]|9|@]|A|$]]|$1|1H|3|-4|5|6|7|42|8|@]|9|@]|A|$]]|$1|1I|3|-4|5|6|7|43|8|@]|9|@]|A|$]]|$1|1J|3|V|5|6|7|44|8|@]|9|@]|A|$]]|$1|1K|3|V|5|L|7|45|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|Y|7|46|8|@]|9|@]|A|$]]|$1|1N|3|-4|5|6|7|47|8|@]|9|@]|A|$]]|$1|1O|3|-4|5|6|7|48|8|@]|9|@]|A|$]]|$1|1P|3|-4|5|6|7|49|8|@]|9|@]|A|$]]|$1|1Q|3|-4|5|6|7|4A|8|@]|9|@]|A|$]]|$1|1R|3|V|5|6|7|4B|8|@]|9|@]|A|$]]|$1|1S|3|V|5|L|7|4C|8|@]|9|@]|A|$]]|$1|1T|3|1U|5|Y|7|4D|8|@]|9|@]|A|$]]|$1|1V|3|-4|5|6|7|4E|8|@]|9|@]|A|$]]|$1|1W|3|-4|5|6|7|4F|8|@]|9|@]|A|$]]|$1|1X|3|-4|5|6|7|4G|8|@]|9|@]|A|$]]|$1|1Y|3|-4|5|6|7|4H|8|@]|9|@]|A|$]]|$1|1Z|3|V|5|6|7|4I|8|@]|9|@]|A|$]]|$1|20|3|V|5|L|7|4J|8|@]|9|@]|A|$]]|$1|21|3|22|5|Y|7|4K|8|@]|9|@]|A|$]]|$1|23|3|-4|5|6|7|4L|8|@]|9|@]|A|$]]|$1|24|3|-4|5|6|7|4M|8|@]|9|@]|A|$]]|$1|25|3|-4|5|6|7|4N|8|@]|9|@]|A|$]]|$1|26|3|-4|5|6|7|4O|8|@]|9|@]|A|$]]|$1|27|3|V|5|6|7|4P|8|@]|9|@]|A|$]]|$1|28|3|29|5|6|7|4Q|8|@]|9|@]|A|$]]|$1|2A|3|2B|5|L|7|4R|8|@]|9|@]|A|$]]|$1|2C|3|2D|5|L|7|4S|8|@]|9|@]|A|$]]|$1|2E|3|2F|5|L|7|4T|8|@]|9|@]|A|$]]|$1|2G|3|2H|5|L|7|4U|8|@]|9|@]|A|$]]|$1|2I|3|2J|5|L|7|4V|8|@]|9|@]|A|$]]|$1|2K|3|-4|5|6|7|4W|8|@]|9|@]|A|$]]|$1|2L|3|-4|5|6|7|4X|8|@]|9|@]|A|$]]|$1|2M|3|2N|5|6|7|4Y|8|@$F|4Z|G|50|H|I]]|9|@]|A|$]]|$1|2O|3|2P|5|L|7|51|8|@]|9|@]|A|$]]|$1|2Q|3|2R|5|L|7|52|8|@]|9|@]|A|$]]|$1|2S|3|2T|5|L|7|53|8|@]|9|@]|A|$]]|$1|2U|3|2V|5|L|7|54|8|@]|9|@]|A|$]]|$1|2W|3|-4|5|6|7|55|8|@]|9|@]|A|$]]|$1|2X|3|-4|5|6|7|56|8|@]|9|@]|A|$]]|$1|2Y|3|2Z|5|6|7|57|8|@]|9|@]|A|$]]|$1|30|3|31|5|6|7|58|8|@]|9|@$F|59|G|5A|1|5B]]|A|$]]|$1|32|3|-4|5|6|7|5C|8|@]|9|@]|A|$]]]|33|$34|$5|35|36|37|A|$38|39]]]]

Having struggled with this for the past few hours I thought it might be valuable to share another method for anyone else still unable to configure an SSRS instance to send subscription emails via gmail using their smtp relay service.

For this example, my company uses Gmail Servers to host our own domain and I assume that you have access to the Admin Console on Google Apps.

Step 1 - Configure Gmail

<ul>
<li>Log into Google Apps with an Administrator Account</li>
<li>Go into the admin console</li>
<li>Select Apps > Gmail > Advanced Settings</li>
<li>Find SMTP Relay Service</li>
<li>Add New</li>
<li><ol>
<li>Allowed Senders - Set to "Only Addresses In My Domains"</li>
</ol></li>
<li><ol start="2">
<li>Authentication - Set to "Only Accept Mail From Specified IP"</li>
</ol></li>
<li><ol start="3">
<li>Add the Public IP Range of the Server SSRS is running on</li>
</ol></li>
<li><ol start="4">
<li>Leave TLS Encryption Unchecked</li>
</ol></li>
<li><ol start="5">
<li>Leave SMTP Authentication Unchecked</li>
</ol></li>
<li><ol start="6">
<li>Save</li>
</ol></li>
</ul>

You should then have settings that look like this:

<ul>
<li>Allowed senders: Only addresses in my domains</li>
<li>Only accept mail from the specified IP addresses: Yes</li>
<li>Allowed IP addresses: (Your Description)</li>
<li>Require SMTP Authentication: No</li>
<li>Require TLS encryption: No</li>
</ul>

Step 2 - Configure SSRS

<ul>
<li>Go to SSRS Configuration Manager > Email Settings</li>
<li>Enter Sender address as email@yourgmaildomain.co.uk</li>
<li>Use SMTP Server</li>
<li>SMTP Server = "smtp-relay.gmail.com"</li>
</ul>

Following these steps will allow you to send emails using SSRS subscriptions without needing to set up your own relay server. Hope this helps some other poor sole from spending hours trying to figure it out!

REF:
<a href="https://support.google.com/a/answer/2956491?vid=1-635782669150538047-3380580329" rel="nofollow">https://support.google.com/a/answer/2956491?vid=1-635782669150538047-3380580329</a>

blocks|key|244223|text|我在2017年的SSRS连接上遇到了问题。我尝试了十几种不同的建议，最后得出了以下结论。我不需要在windows服务器上设置SMTP中继或SMTP服务。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|244224|打开Reporting配置管理器。转到-电子邮件设置>>>|offset|length|style|BOLD|244225|发件人地址:+user@gmail.com+(或您的G-套房域名)|unordered-list-item|244226|当前传递方法:使用SMTP服务器|244227|SMTP服务器:+smtp.gmail.com|244228|Authentication=“用户名和密码(基本)”|244229|用户名:+user@gmail.com+(或您的G-Suite域)|244230|密码|244231|确认密码|244232|使用安全连接:已检查|244233|244234|244235|现在转到rsreportserver.config文件。我的位置是C:\Program+\报告Services\SSRS\ReportServer\rsreportserver.config|244236|查找<SMTPServerPort>并设置为587|CODE|244237|Save+rsreportserver.config|244238|entityMap^0|0|2|E|J|7|0|0|0|0|0|0|0|0|0|0|0|4|L|0|2|G|M|3|2|G|0|0|4|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@$D|1B|E|1C|F|G]|$D|1D|E|1E|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1F|8|@]|9|@]|A|$]]|$1|K|3|L|5|J|7|1G|8|@]|9|@]|A|$]]|$1|M|3|N|5|J|7|1H|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|1I|8|@]|9|@]|A|$]]|$1|Q|3|R|5|J|7|1J|8|@]|9|@]|A|$]]|$1|S|3|T|5|J|7|1K|8|@]|9|@]|A|$]]|$1|U|3|V|5|J|7|1L|8|@]|9|@]|A|$]]|$1|W|3|X|5|J|7|1M|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1P|8|@$D|1Q|E|1R|F|G]]|9|@]|A|$]]|$1|12|3|13|5|6|7|1S|8|@$D|1T|E|1U|F|G]|$D|1V|E|1W|F|G]|$D|1X|E|1Y|F|14]]|9|@]|A|$]]|$1|15|3|16|5|6|7|1Z|8|@$D|20|E|21|F|G]]|9|@]|A|$]]|$1|17|3|-4|5|6|7|22|8|@]|9|@]|A|$]]]|18|$]]

I was having a problems getting SSRS 2017 to connect. I tried a dozen different suggestions and ended up with the following. I didn't need to setup the SMTP relay or SMTP service on the windows server. 

Open Reporting Services Configuration Manager. Go to E-mail Settings >>>

<ul>
<li>Sender Address: [user]@gmail.com (or your G-Suite domain)</li>
<li>Current Delivery Method: Use SMTP server</li>
<li>SMTP Server: smtp.gmail.com</li>
<li>Authentication= "Username and password (basic)"</li>
<li>Username: [user]@gmail.com (or your G-Suite domain)</li>
<li>Password</li>
<li>Confirm Password</li>
<li>Use Secure Connection: Checked</li>
</ul>

Now go to the rsreportserver.config file. Mine was located at 
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\rsreportserver.config

Find the <code>&lt;SMTPServerPort&gt;</code> and set to 587

Save rsreportserver.config

I have a report using SSRS 2008 R2, I want to subscribe to this report using the "email" option. I have configured the settings in the reporting services manager to use server as "smtp.gmail.com" and sender address as my gmail ID.

I also tried using the SMTP virtual server and relay it using smart host as "smtp.gmail.com". But I get the following error while sending email : 

<blockquote>
 Failure sending mail: The transport failed to connect to the server.
</blockquote>

I am using IIS 7 and Windows Server 2008. Following is the snippet of my <code>rsreportserver.config</code> file:

<pre><code>&lt;SMTPServer&gt;smtp.gmail.com&lt;/SMTPServer&gt;
&lt;SMTPServerPort&gt;587
&lt;/SMTPServerPort&gt;
&lt;SMTPAccountName&gt;
&lt;/SMTPAccountName&gt;
&lt;SMTPConnectionTimeout&gt;
&lt;/SMTPConnectionTimeout&gt;
&lt;SMTPServerPickupDirectory&gt;
&lt;/SMTPServerPickupDirectory&gt;
&lt;SMTPUseSSL&gt;True
&lt;/SMTPUseSSL&gt;
&lt;SendUsing&gt;2&lt;/SendUsing&gt;
&lt;SMTPAuthenticate&gt;&lt;/SMTPAuthenticate&gt;
&lt;From&gt;myid@gmail.com&lt;/From&gt;
</code></pre>

Any help will be highly appreciated.
Thanks

How to use gmail account for ssrs email subscription

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个使用SSRS 2008 R2的报告，我想使用"email“选项订阅此报告。我已经将reporting管理器中的设置配置为使用服务器作为"smtp.gmail.com“，使用发件人地址作为我的gmail ID。我还尝试使用SMTP虚拟服务器，并使用智能主机作为"smtp.gmail.com“中继它。但是，在发送电...

问如何使用gmail帐户订阅ssrs电子邮件
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用gmail帐户订阅ssrs电子邮件EN