Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I would like to know if it is possible to verify that an SSRS subscription that was set up to send an email sent it to a real address. That is, if I put in an email address that is not valid, can I find out that an undeliverable message was sent back from the destination server?

I tested this with an email address that does return an undeliverable message when I emailed to it from Outlook. After the subscription ran, its status simply said Mail sent to abc@abc.com.

OUR SOLUTION: We set up a shared Outlook account with a generic email address. Those of us who have access to create subscriptions have access to this email account. We then modified the RSReportServer.config file on the ReportServer to send emails from this new generic address. Now, any time a subscription is set up to send to an incorrect email address, we can see the delivery failure in the shared Outlook inbox. Woo hoo!

share|improve this question
1  
This different but related ServerFault anwer may be of help. I'm not sure if things like NDRs even get back to reporting services, you may just have to check your mail server log? –  Jeroen May 15 '12 at 19:58
add comment

1 Answer

up vote 2 down vote accepted

The easiest way to do it is to set up a Reply email: address when you you are configuring database mail. This will send the bounce back messages to that email account.

UPDATE:

The bounce-back for invalid email addresses will go to the FROM address. The Reply-To address is used only by an email program when a user tries to reply to the message. Change the FROM email address and see if you get the bounce-back your inbox.

If you get the bounce-back to the from address you can setup a mailbox to collect these messages.

share|improve this answer
    
I tried to set the reply-to at the subscription level and it did not appear to work. My impression was that reply-to would override the server setting. Any thoughts? –  JHFB May 16 '12 at 11:41
    
Please see the updated information above. Test out the FROM address and see if you see bounce-back emails going there. –  jgardner04 May 16 '12 at 13:53
    
That makes sense - that it would go to the FROM. It will take a bit more maneuvering for me to test this, but sounds promising! –  JHFB May 16 '12 at 14:08
    
This worked perfectly. I have updated the question with my solution. –  JHFB May 30 '12 at 14:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.