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

Posted on 2005-04-06
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

    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    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…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now