Groups | Blog | Home
all groups > sql server reporting services > february 2005 >

sql server reporting services : E-mail address of one or more recipients is not valid


John R
2/23/2005 2:27:06 PM
We have setup Reporting Services on a Server 2003 box with SMTP intalled on
it. I am able to write a simple VB Script that uses CDO to send a e-mail out
to a certain address (let's say to john@test.com). When I setup a
subscription using the same e-mail address I get the error "The e-mail
address of one or more recipients is not valid." Does anyone know why - if I
John R
2/23/2005 3:11:04 PM
I've figured out what my problem is - apparently SQL Server Reporting
Services is not authenticating correctly. I had to change the settings on
the Relay Restictions on the Access tab for the SMTP Server Properties to be
allow relay through the virtual server with "All except the list below"
instead of the default "Only the list below". Seems like it should work with
the default setting since there is no authentication (anonymous access) but
looks like RS doesn't like that.

[quoted text, click to view]
AddThis Social Bookmark Button