Start SQL Agent Service

Problem

You may encounter the following error when creating subscriptions for the first time in the SSRS.

SQL Agent service is not running

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:

1. Go to Services.msc. Access this by typing services.msc in the Windows Search Box.

2. Click Services.

   

   Services.msc

   
   

3. Scroll down and look for SQL Server Agent (MSSQLSERVER). Right-click on it, then choose Properties.

   

   Services - SQL Server Agent

   
   

4. In the General tab, click on Start under the Service status.

5. You can also determine the Startup type of the service by choosing from the drop-down list. Choose Automatic to have the service run on startup.

6. Click on Apply, then click OK to save the changes.

   

   SSQL Server Agent - Properties