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

sql server reporting services : Email subscriptions


Jeff McIntire
7/14/2005 10:49:04 AM
Hello all,

I am trying to get some email subscriptions setup and I keep getting the
message "The e-mail address of one or more recipients is not valid". The
email address is valid and I am not sure what the problem is. If I set the
email address to a local account name (i.e Administrator) the subscription
works and e-mail shows up in the drop folder of the smtp server. Does anyone
know how I can get my subscriptions working to real email addresses and not
just local accounts? Any help would be appreciated.

Thanks,

Jeff McIntire
7/14/2005 11:56:02 AM
I have solved my own issue. All I needed to do was edit the SMTP server
settings to grant access to the server to relay through its own IP address.

Jeff

[quoted text, click to view]
DougM
8/23/2005 5:48:20 PM
How exactly did you do that? I have looked around for hours, you're the only
that has my exact same problem.

[quoted text, click to view]
Jeff McIntire
8/23/2005 5:58:06 PM
All I did was go to the SMTP server properties and click on the access tab.
Then I clicked the relay button at the bottom of the page. Next I clicked on
add and inputted the IP address of my server. Then I clicked ok and made
sure the radio button labeled “Only the list below” was selected. That
solved my problem and I hope it solves yours as well.

Thanks,

Jeff


[quoted text, click to view]
DougM
8/23/2005 6:25:01 PM
Thanks, I tried re-installing Reporting Services to see if I could see that
screen but after choosing to modify components (as opposed to uninstall) it
went right through to finish....How did you get to the SMTP properties?. I
appreciate your help very much.

Regards,

DougM

[quoted text, click to view]
Jeff McIntire
8/24/2005 9:08:03 AM
I am sorry. Perhaps I should have clarified. The SMTP properties that I was
referring to were in the SMTP server in IIS itself. If you open up IIS and
navigate to the SMTP server and then right click on it and go to properties
you should find the screens that I was referring to.

Thanks,

Jeff


[quoted text, click to view]
ravi
1/2/2009 8:52:23 PM
Change your report configuration file..

SMTPServerPickupDirectory =C:\Inetpub\mailroot\Pickup
SMTPAccountName=Administrator
SMTPAuthenticate=0
SendUsing=1

From http://www.developmentnow.com/g/115_2005_7_0_0_560723/Email-subscriptions.htm

Posted via DevelopmentNow.com Groups
AddThis Social Bookmark Button