#
Start SQL Agent Service
#
Problem
When creating subscriptions for the first time in the SSRS, an error will show saying that the SQL Agent service is not running in your machine.
The SQL Agent Service is required when creating subscriptions in SSRS. By default, the service is not running.
#
Resolution
To start the service, follow these instructions:
Go to
Services.msc
. Access this by typing services.msc in the Windows Search Box.Click on
Services
.Services.mscScroll down and look for SQL Server Agent (MSSQLSERVER). Right-click on it and choose Properties.
Services - SQL Server AgentIn the General tab, click on Start under the Service status.
You can also determine the Startup type of the service by choosing from the drop-down list. Choose Automatic to have the service running on startup.
Click on Apply, then click OK to save the changes.
SQL Server Agent - Properties