July 24, 2019 at 6:58 pm
We are running SSRS 2016 - Product Version 13.0.5337.0 - and I have a report for which I set up a subscription to have it delivered a distribution group callled "Company X PMO" plus other individuals who do not belong to that group. The individuals who do not belong to the group are receiving the email subscription each morning but not any of the members of the distribution group.
Per instructions I found from Microsoft, I modified the rsreportserver.xml file to the following value:
<SMTPAuthenticate>2</SMTPAuthenticate>
Configure a Report Server for E-Mail Delivery
Some other notes that may be of interest, the RS Service Account runs under a domain account like "CompanyX\CompanyXSQLAdministrator" and the Sender Address has been configured as "noreply@companyX.com".
I have asked for verification that the "CompanyX\CompanyXSQLAdministrator" account has "Send As" permissions on the mailbox, but the group still does not receive the email subscription. I don't have access to the Exchange server so I have to trust these setting were changed correctly.
I can't find much documentation on this issue besides a post on Stack Overflow and one on Experts-Exchange but does anyone have any other suggestions on how to get this working?
July 24, 2019 at 8:05 pm
Is the group an Exchange group - as in a DL - or an email group in AD? If the DL is not defined with an email address it will not be accessible through the SMTP gateway.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 24, 2019 at 8:15 pm
Thanks for the reply - I will have to check with the Exchange admin to find out.
July 25, 2019 at 7:57 am
" distribution group callled "Company X PMO""
It can be also a security group in AD and not distribution list at all.
August 8, 2019 at 6:21 pm
Sorry for the delayed response - I reached out to our Operations Manager and was informed this is a distribution group with a defined email address of CompanyX_PMO@CompanyX.com.
I'm not sure what else can be done - I'm almost positive this would be an Exchange setting somewhere preventing this subscription from working.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply