MSSQL Reporting Services 2000 on Windows Server 2003
MS Exchange 2007 on Windows Server 2007
I have a report subscription that I need to deliver to a user with an email address outside the domain.
I have set up the following for both the user and myself:
An exchange mailbox
A contact forward
A Mail Flow setup on the exchange mailbox that forwards to the contact
The report is addressed to the user's exchange address as well as my exchange address. When it executes, I receive the report on my external (forwarded) address, but the user does not. I can see the user's exchange address in the cc field of the message.
The user swears that the report is not in his junk mail folder.
If I forward the report (or any other email) from my external address to the user's exchange address, he receives it correctly at his external (forwarded) address.
How do I troubleshoot this beyond what I have done?
EDIT:
We are getting a 550 Administrative Prohibition status back from the user's email host. I checked our server's ip on http://www.mxtoolbox.com/blacklists.aspx and everything comes up clean. Note that some messages are forwarded to this user successfully.
Best Answer
Try to find the Non-Delivery Report (NDR) for your outgoing email, then follow the troubleshooting steps on this Technet page.
The simplest path would be to try sending the report file to the external address from an internal mailbox which you DO have access to. This should result in an NDR email being sent to the internal mailbox, which will tell you what is going wrong.
Once you have an idea why the delivery is failing from an Exchange mailbox, you'll want to verify that failure code is actually the same when the Reporting Server sends the email. Assuming that your Reporting Server is sending the email out via SMTP directly, you will have to find the NDR in a log somewhere else, since there may be no mailbox to send the NDR to. This page has good information on How to Monitor Exchange NDRs.