Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am running MOSS with SQL Server 2005 Reporting Services in integrated mode. There are a number of reports that are generated and then output emailed through SharePoint's subscriptions. Sporadically all subscriptions will fail to email with the error message of "Failure sending mail: Report Server has encountered a SharePoint error."

Can any one shed any light as to why this is occuring and what I can do to prevent it?

share|improve this question
1  
Does the error returns an error code? Or maybe more details on the error? Did you check the log on the report server? –  MarlonRibunal May 4 '09 at 22:30
    
Have you turned on verbose logging on the sharepoint server? It may show the error there. Note though that logging verbosely may impact the performance of the server. –  Jonathan Parker May 11 '09 at 6:05

1 Answer 1

up vote 2 down vote accepted
+75

To see the status of your subscriptions and when they last executed, you can perform a query: http://feedproxy.google.com/~r/sqlserverpedia/~3/O78C3knsUO0/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.