The e-mail address of one or more recipients is not valid error from SSRS

Our current sql server is SQL Server 2005 and we use Exchange 2007.

Today we attempted to use SSRS to send a report outside of our domain and when the report ran, we noticed that subscription’s status was “The e-mail address of one or more recipients is not valid”.

Subscription Status

Subscription Status

We knew we had good email addresses, so we decided to look elsewhere for the answer to the issue.

Our SSRS email settings looked like this

SSRS email settings

SSRS email settings

Based on the answer here we modified the Allowed Relay properties and added the sql server’s ip address to the “Receive mail from remote servers that have these IP addresses” section (While in the Exchange Management Console, select Hub Transport under Server Configuration, select Receive Connectors, then right click on the Allow Relay entry…Select the Network tab, then add or edit the sql server ip address in the “Receive mail from remote servers that have these IP addresses” section).

After adding the sql server’s ip address as above, the subscription worked!

Advertisements

About w4ik

software engineer...in the trenches
This entry was posted in SSRS 2005. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s