70-467 · Question #71
You need to re-establish subscriptions on SSRS01. What should you do?
The correct answer is A. Start the SQL Server Agent on SSRS01. SSRS subscriptions are scheduled and executed by SQL Server Agent, so subscriptions fail to run when the Agent service is stopped.
Question
You need to re-establish subscriptions on SSRS01. What should you do?
Options
- AStart the SQL Server Agent on SSRS01.
- BRestore the ReportServer database.
- CRestore the ReportServerTempDB database.
- DUse the SQL Server Configuration Manager to reset the SQL Service account credentials.
How the community answered
(27 responses)- A89% (24)
- B4% (1)
- D7% (2)
Why each option
SSRS subscriptions are scheduled and executed by SQL Server Agent, so subscriptions fail to run when the Agent service is stopped.
SQL Server Reporting Services relies entirely on SQL Server Agent to schedule and trigger subscription deliveries. If the Agent service is not running on SSRS01, all subscriptions remain queued but never execute - starting the Agent service immediately re-enables subscription processing without requiring any data restore or reconfiguration.
Restoring the ReportServer database would recreate subscription definitions, but the issue is the Agent service not running, not missing subscription metadata.
ReportServerTempDB holds temporary session and snapshot data only and has no role in scheduling or delivering subscriptions.
Resetting the SQL Service account credentials in Configuration Manager addresses service startup authentication failures, not subscription execution which depends on Agent being active.
Concept tested: SSRS subscription dependency on SQL Server Agent
Source: https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/create-and-manage-subscriptions-for-native-mode-report-servers
Topics
Community Discussion
No community discussion yet for this question.