Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Send SQLReport Snapshot through email (database mail) Expand / Collapse
Author
Message
Posted Monday, January 28, 2008 2:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 9:38 AM
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.
Post #448164
Posted Monday, January 28, 2008 5:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:12 PM
Points: 5,615, Visits: 6,413
Are you sure you don't have a typo on the email address in the subscription?



Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #448235
Posted Monday, January 28, 2008 8:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 9:38 AM
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".
Post #448669
Posted Tuesday, January 29, 2008 4:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:12 PM
Points: 5,615, Visits: 6,413
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 Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #448753
Posted Wednesday, January 30, 2008 10:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 9:38 AM
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]




  Post Attachments 
subscription.JPG (44 views, 61.42 KB)
Post #449795
Posted Thursday, January 31, 2008 4:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:12 PM
Points: 5,615, Visits: 6,413
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 Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #449863
Posted Friday, February 1, 2008 6:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:48 AM
Points: 149, Visits: 1,088
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
Post #450439
Posted Sunday, February 3, 2008 10:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 9:38 AM
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.
Post #451003
Posted Monday, February 4, 2008 4:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:12 PM
Points: 5,615, Visits: 6,413
I am completely out of ideas at this point. You probably should call Microsoft support.

Sorry I couldn't help.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #451076
Posted Friday, February 15, 2008 10:02 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 7:31 PM
Points: 675, Visits: 6,816
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
Post #456395
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse