Report Server not Sending Emails to External email adresses

I have set up a new reporting server on SQL 2008 R2 when I created subscriptions to send out reports within the business this works fine.

However when I try to send to any external Emial address. the report does not send. (the external email adresses are correct)

asked Jan 17 '12 at 11:35 PM in Default

HRugbeer
91 ● 8 ● 12 ● 19

(comments are locked)

3 answers:

Not sure if you have this fixed or not yet, in addition I am not sure if this is much help but in the past when I had that problem it was an issue on the exchange server. Something you may want to consider as another avenue to research.

answered Jan 18 '12 at 06:36 AM

Chris shaw
520 ● 2 ● 2 ● 5

(comments are locked)

Check the report server logs for information about sending the message to smtp. If there is some issue during sending the message, then there will be some info available in the logs.

If the problems are cases as @Usman Butt described like internal policy which doesn't allow sending emails outside organization in that case you should discuss this with your email server administrators. In some organization you need to have an approval to send email outside and the sender emailn nedds to be approved for this.

answered Jan 18 '12 at 06:17 AM

Pavel Pawlowski
20.3k ● 5 ● 10 ● 20

(comments are locked)

Are you sure you are allowed to send email to external addresses? Make sure there is no such organization policy which prohibits sending emails to outside. Have you configured your MAIL SERVER correctly? Please visit these following BOL links, may be something you missed

http://msdn.microsoft.com/en-us/library/ms159155.aspx

http://msdn.microsoft.com/en-us/library/ms160334.aspx

http://technet.microsoft.com/en-us/library/ms345234.aspx

answered Jan 18 '12 at 12:00 AM

Usman Butt
13.8k ● 6 ● 8 ● 14

Hi. I have checked on this, and there was no restrictions.

Jan 18 '12 at 12:10 AM HRugbeer

From the report server I would telnet (if permissions allow it) to the mail server and try a spoof an email to an external address.

http://support.microsoft.com/kb/153119

Jan 18 '12 at 12:43 AM sp_lock

@Jonlee Lockwood +1. This was what I was about to say. Another thing came to mind is the typical restriction on types and size of attachments in most of the organizations. @HRugbeer Are you sure that is not the case either? Depending upon your type of mail server, you could also trouble shoot by seeing the delivery failed notifications at MAIL SERVER. Moreover, please go through the BOL links I have posted, these could help you a great deal.

Jan 18 '12 at 12:56 AM Usman Butt

(comments are locked)