Post reply

SSRS 2005 Subscription Issue

  • February 22, 2008 at 9:32 am

    #183273

    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

  • February 22, 2008 at 4:30 pm

    #781306

    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

  • March 26, 2008 at 12:05 pm

    #794253

    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.

  • April 7, 2008 at 8:34 am

    #799193

    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.

  • May 29, 2008 at 6:08 am

    #821705

    Can you please explain exact steps to resolve the issue. I have same problem and I don't know how to resolve it.

  • December 23, 2008 at 11:15 pm

    #917230

    how u resolve that problem?

    Can you please explain exact steps to resolve the issue. I have same problem.

  • December 24, 2008 at 5:40 am

    #917322

    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

  • September 6, 2011 at 1:15 pm

    #1377648

    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.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply