Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Report Subscription Problem

Author  Topic 

learntsql

524 Posts

Posted - 2010-04-19 : 04:30:41
I have made subscription for one report and when i see in reportmanager it's showing Mail sent but subscriber is not recieving mail.
How to troubleshoot this issue?
Where can i see Queued mails either in windows or ReportManager?
TIA

theboyholty
Posting Yak Master

226 Posts

Posted - 2010-04-30 : 11:14:28
As far as I am aware, there's no queue manager although the ExcecutionLog would confirm that the report has run. What i'd do in these circumstances is to include myself as a cc on the report subscription. Then you'll be able to at least pinpoint where in the process its fouling up.
Whenever my users tell me they've 'not received' a report, 9 times out of 10, they've deleted it or had some rule set up to syphon it off to a different folder in Outlook. Also check their Junk mail in case your reporting server is set up as a disallowed email sender address.

---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club
Go to Top of Page
   

- Advertisement -