SQL Server Reporting Services Subscriptions - Stuck with Pending Status
Submitted by webmaster on Fri, 06/12/2015 - 12:41There was a problem with a SQL Server Reporting Server: new subscriptions were not working and the Status on the report subscription would show as Pending after it started.
Deleting and recreating the subscription did not fix the issue. Reviewing the reporting service configuration did not show any bad or missing configurations. We looked deeper and found the fix to this issue. Looking back, it seems this is a simple fix but to help prevent someone else from spending a lot of time in troubleshooting we decided to write this post.