up vote 3 down vote favorite
share [g+] share [fb]

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?

link|improve this question
25% accept rate
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
feedback

1 Answer

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/

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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