SCCM | SQL Agent service is not running

Overview

Below error appears when creating a report subscription. ‘The SQL Agent service is  not running’.

 

 

 

 

Issue

Unable to create report subscription.

Resolution

  1. RDP onto the SQL server hosting the SCCM database
  2. Open SQL Server Configuration Manager
  3. Select ‘SQL Server Services’ in the left hand pane. On the right hand pane right-click ‘SQL Server Agent (MSSQLSERVER)’ > Properties
  4. Change the ‘Start Mode’ from Manual to Automatic
  5. Apply the settings and check if the service is already running. If not start it
  6. Try again and it will create successfully.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.