how to trobleshoot Email subscription problems in MS SQL Reporting Services?

Posted on 2005-04-06
Medium Priority
Last Modified: 2012-05-05

  I setup a test subscription in reporting services.
  It was  a one time test - and under "status" it says:

 Failure sending mail: An error has occurred during report processing.

  how do I go about troublshooting this? Are there any log files somewhere that could tell me more about the error so I can track it down?

- Jack
Question by:fruhj
LVL 14

Accepted Solution

simon_kirk earned 2000 total points
ID: 13724937
You will need to look in the reportserverservice<date>.log file to find out what is happening.  The problem is likely to be processing the report, not delivering it, so does the report work with no problems within Report Manager? The log file should contain more information and can be found under this directory:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
LVL 12

Author Comment

ID: 13726668
Simon, you are quickly becoming my hero.
I really appreciate all your responses!
- Jack

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
How to increase the row limit in Jasper Server.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month16 days, 20 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question