﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2005 / Business Intelligence  / SSRS 2005 Subscription Issue / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Fri, 24 May 2013 09:43:59 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: SSRS 2005 Subscription Issue</title><link>http://www.sqlservercentral.com/Forums/Topic459180-147-1.aspx</link><description>Fought this issue for a while, so wanted to report back the fix for my system.Mine ended up being an Exchange-Authentication problem.. here's the Exchange Powershell script to fix it:Get-ReceiveConnector "Local Relay" | Add-ADPermission -User "NT Authority\ANONYMOUS LOGON" -ExtendedRights "ms-Exch-SMTP-Accept-Any-Recipient"And then just Restart Service "Microsoft Exchange Transport" to seal the deal.</description><pubDate>Tue, 06 Sep 2011 13:15:21 GMT</pubDate><dc:creator>aaronsql</dc:creator></item><item><title>RE: SSRS 2005 Subscription Issue</title><link>http://www.sqlservercentral.com/Forums/Topic459180-147-1.aspx</link><description>To be honest with you - it's been so long I can't remember how I got it working.I've looked through the config tools and can't see anywhere to specify permitted hosts.If you're on Exchange, have you made sure the relay allows external email sends?  Have you tried what Shawn suggested below?Sorry I can't be more help.Dan</description><pubDate>Wed, 24 Dec 2008 05:40:42 GMT</pubDate><dc:creator>Dan Colbert-387424</dc:creator></item><item><title>RE: SSRS 2005 Subscription Issue</title><link>http://www.sqlservercentral.com/Forums/Topic459180-147-1.aspx</link><description>how u resolve that problem?Can you please explain exact steps to resolve the issue. I have same problem.</description><pubDate>Tue, 23 Dec 2008 23:15:19 GMT</pubDate><dc:creator>laxme24</dc:creator></item><item><title>RE: SSRS 2005 Subscription Issue</title><link>http://www.sqlservercentral.com/Forums/Topic459180-147-1.aspx</link><description>Can you please explain exact steps to resolve the issue. I have same problem and I don't know how to resolve it.</description><pubDate>Thu, 29 May 2008 06:08:41 GMT</pubDate><dc:creator>Abbas Malik-298105</dc:creator></item><item><title>RE: SSRS 2005 Subscription Issue</title><link>http://www.sqlservercentral.com/Forums/Topic459180-147-1.aspx</link><description>Thanks for the responses to this post.  I finally got it resolved.It turns out my XML editing skills are lacking.  When I edited the email setup using the SSRS config tool it worked fine.</description><pubDate>Mon, 07 Apr 2008 08:34:43 GMT</pubDate><dc:creator>Dan Colbert-387424</dc:creator></item><item><title>RE: SSRS 2005 Subscription Issue</title><link>http://www.sqlservercentral.com/Forums/Topic459180-147-1.aspx</link><description>You need to modify the RSreportserver.config file to have each external domain permitted...[code]     &amp;lt;PermittedHosts&amp;gt;          &amp;lt;HostName&amp;gt;Adventure-Works.com&amp;lt;/HostName&amp;gt;          &amp;lt;HostName&amp;gt;hotmail.com&amp;lt;/HostName&amp;gt;     &amp;lt;/PermittedHosts&amp;gt;[/code]You won't need to restart reporting services.I'm trying to work around the issue of permitting all domains, but haven't got it to work yet.[code]&amp;lt;SendEmailToUserAlias&amp;gt;False&amp;lt;/SendEmailToUserAlias&amp;gt;&amp;lt;DefaultHostName&amp;gt;&amp;lt;/DefaultHostName&amp;gt;     &amp;lt;PermittedHosts&amp;gt;          &amp;lt;HostName&amp;gt;&amp;lt;/HostName&amp;gt;     &amp;lt;/PermittedHosts&amp;gt;[/code]I have tried different combinations like filling in defaulthostname, removing hostname, removing permittedhosts.  I haven't tried a wild card yet in HostName.  If anybody finds out, please let me know...I'm using a remote smtp server.</description><pubDate>Wed, 26 Mar 2008 12:05:17 GMT</pubDate><dc:creator>Shawn-456755</dc:creator></item><item><title>RE: SSRS 2005 Subscription Issue</title><link>http://www.sqlservercentral.com/Forums/Topic459180-147-1.aspx</link><description>Hi Dan,I'm having the same problem.  I'm working on it right now and if I find something I'll share it with you.Dave</description><pubDate>Fri, 22 Feb 2008 16:30:47 GMT</pubDate><dc:creator>davidjsutherland</dc:creator></item><item><title>SSRS 2005 Subscription Issue</title><link>http://www.sqlservercentral.com/Forums/Topic459180-147-1.aspx</link><description>I've looked for a resolution to this in several places and have had no luck.When I set up a subscription for a report, internal email addresses work just fine.  When I include an external domain as one of the recipients, I get "The e-mail address of one or more recipients is not valid." as my error.I've made sure the exchange relay is set up appropriately.  (I've successfully sent to external domains through SQL management studio.)  I've set the SendEmailToUserAlias flag to "False".  I've added specific domains to the PermittedHosts node of the config file.  I'm at a loss... :sick:Has anyone experiences and solved this issue?Thanks in advance!Dan</description><pubDate>Fri, 22 Feb 2008 09:32:59 GMT</pubDate><dc:creator>Dan Colbert-387424</dc:creator></item></channel></rss>