SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Send SQLReport Snapshot through email (database mail)


Send SQLReport Snapshot through email (database mail)

Author
Message
jyothiprasad
jyothiprasad
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 24
I have setup database mail, in SQL2005 reporting service, Am able to send Test mail properly. I deployed a Report and scheduled to create snapshot and send email (defined to send PDF file, am able to view the report through report manager). It is creating snapshot at the scheduled time, but throwing error "The e-mail address of one or more recipients is not valid." and mails are not going. using a remote mail server for sending. I am able to send mail to the given email id, through the Testmail option.

Please help me to setup and send SQL reports (snapshots) using subscription.
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14365 Visits: 8978
Are you sure you don't have a typo on the email address in the subscription?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
jyothiprasad
jyothiprasad
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 24
The e-mail address given in the subscription is a valid one. It is creating the snapshot, but showing the status as "The e-mail address of one or more recipients is not valid".
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14365 Visits: 8978
Just a note, I don't think SSRS cares about the email address when it creates a snapshot. A bad email wouldn't cause it to not create the snapshot. That's why I'm asking if you double-checked what you typed for the email address in the subscription. I've done that before, typo'd one letter and not caught it. But if you've already double-checked the email address in the subscription to make sure you didn't mistype it...

How many people are you sending out the snapshot to? Just one? Or are there multiple email addresses?

If multiple, how are you separating out the email addresses from each other?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
jyothiprasad
jyothiprasad
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 24
I am putting single email address. The screen shot is available in the link [url=http://www.sqlservercentral.com/Forums/Attachment343.aspx][/url]
Attachments
subscription.JPG (54 views, 61.00 KB)
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14365 Visits: 8978
Have you tried testing this report with your own internal email address? It might be you're having problems because you're trying to send the report to an external address.

I'm guessing at this point, though.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
smv929
smv929
SSC Veteran
SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)

Group: General Forum Members
Points: 219 Visits: 1137
I too have had the same message. I set up a subscription that works when I send to a list of VALID email addresses specified in the format:

email1@xyz.com; email2@xyz.com; email3@xyz.com

I get an error message indicating there is an invalid email address when...

1. the list contains an invalid email address (i.e., when an employee leaves the company)

2. I use an Outlook Group name, which is what I wanted to do originally, instead of a list of of email addresses. Obviously, it's easier to manage the receipient list for several subscriptions that all sent to a group name instead of having to modify a long list of email addresses in several subscriptions. I would specify the Outlook group name by supplying our email suffix, as in: EmailGroupName@xyz.com. But that doesn't work either.

Anyone have any suggestions for a better way to manage email addresses.


smv929
jyothiprasad
jyothiprasad
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 24
I tried to send it to my internal email id initially that time also I got the failure status, then I changed to external Id, the same failure status is thrown.
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14365 Visits: 8978
I am completely out of ideas at this point. You probably should call Microsoft support.

Sorry I couldn't help.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Greg Edwards-268690
Greg Edwards-268690
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1497 Visits: 8481
Might be a dumb question - but did you use rsconfig to configure email for Reporting Services?
I use an SMTP server for this, not Database mail.
Check your settings in rsconfig
Greg E
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search