Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2005 Subscription Issue Expand / Collapse
Author
Message
Posted Friday, February 22, 2008 9:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:51 PM
Points: 269, Visits: 338
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...

Has anyone experiences and solved this issue?

Thanks in advance!

Dan
Post #459180
Posted Friday, February 22, 2008 4:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:20 PM
Points: 2, Visits: 19
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
Post #459361
Posted Wednesday, March 26, 2008 12:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 12, 2012 8:52 AM
Points: 1, Visits: 26
You need to modify the RSreportserver.config file to have each external domain permitted...
     <PermittedHosts>
<HostName>Adventure-Works.com</HostName>
<HostName>hotmail.com</HostName>
</PermittedHosts>

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.
<SendEmailToUserAlias>False</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts>
<HostName></HostName>
</PermittedHosts>

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.
Post #474983
Posted Monday, April 07, 2008 8:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:51 PM
Points: 269, Visits: 338
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.
Post #480883
Posted Thursday, May 29, 2008 6:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 29, 2008 8:30 AM
Points: 1, Visits: 7
Can you please explain exact steps to resolve the issue. I have same problem and I don't know how to resolve it.
Post #508330
Posted Tuesday, December 23, 2008 11:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 06, 2012 2:02 AM
Points: 4, Visits: 30
how u resolve that problem?
Can you please explain exact steps to resolve the issue. I have same problem.
Post #625189
Posted Wednesday, December 24, 2008 5:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:51 PM
Points: 269, Visits: 338
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
Post #625305
Posted Tuesday, September 06, 2011 1:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 7:54 AM
Points: 5, Visits: 74
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.
Post #1170674
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse