SSRS 2005 Subscription Issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSRS 2005 Subscription Issue

SSRS 2005 Subscription Issue

Rate Topic

Display Mode

Topic Options

Author

Message

Dan Colbert-387424

Posted Friday, February 22, 2008 9:32 AM

SSC 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... Sick

Has anyone experiences and solved this issue?

Thanks in advance!

Dan

Post #459180

davidjsutherland

Posted Friday, February 22, 2008 4:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 1:58 PM
Points: 2, Visits: 17

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

Shawn-456755

Posted Wednesday, March 26, 2008 12:05 PM

Forum 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

Dan Colbert-387424

Posted Monday, April 07, 2008 8:34 AM

SSC 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

Abbas Malik-298105

Posted Thursday, May 29, 2008 6:08 AM

Forum 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

laxme24

Posted Tuesday, December 23, 2008 11:15 PM

Forum 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

Dan Colbert-387424

Posted Wednesday, December 24, 2008 5:40 AM

SSC 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

aaronsql

Posted Tuesday, September 06, 2011 1:15 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:18 PM
Points: 4, Visits: 52

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 »

Permissions