Sharepoint scheduling with SSRS issue.

Question

I have some scheduled SSRS reports (integrated mode) that get emailed by subscription. All of a sudden the reports have stopped being emailed. I get the error:

Failure sending mail: Report Server has encountered a SharePoint error.

I don't even know where to start to look as I can't get into SSRS and my Sharepoint knowledge is lacking.

Can you help?

Answer 1

Did you enable trace logging in SharePoint? You can activate it by going to the Central Administration website > Operations > Diagnostic Logging > Trace Logging. Perhaps we can get a more detailed error from there...

Answer 2

Is the Reporting Services service running as a domain user account? This Microsoft KB article may be related to your problem:

http://support.microsoft.com/?kbid=842423