none
Report Subscription by email error - The SQL Agent service is not running

    Question

  • Hello All,

    This may be an easy answer, so please excuse my ignorance if I am overlooking something simple. I a simply trying to setup Report Subscriptions to be emailed to me. We currently have essentially 3 servers in use in our environment - a CAS, a Site server and a SQL 2012.

    I have configured the email settings in Reporting Services Configuration Manager on the Site server and was finally able to see the email option in the Create Subscription Wizard, but it errors out with:

    System.Web.Services.Protocols.SoapException: The SQL Agent service is not running. This operation requires the SQL Agent service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SchedulerNotRespondingException: The SQL Agent service is not running. This operation requires the SQL Agent service.   at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateSubscription(String Report, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters, Guid batchId, String& SubscriptionID)   at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateSubscription(String Report, ExtensionSettings ExtensionSettings, String Description, String EventType, String MatchData, ParameterValue[] Parameters, String& SubscriptionID)

    We do not have SQL installed locally, therefore it makes sense that the Agent service is not running. How do I subscribe to alerts in SCCM without a local installation of SQL?


    -Brad

    Friday, January 17, 2014 1:57 PM

Answers

  • Well - turns out simply rebooting the server fixed it - not sure what was pending or preventing it, but problem resolved for now. False alarm. Thanks for the fast feedback, gentlemen.

    -Brad

    • Marked as answer by Brad M Laszlo Friday, January 17, 2014 9:32 PM
    Friday, January 17, 2014 9:32 PM

All replies

  • Is the SQL agent running on the sql server?

    Torsten Meringer | http://www.mssccmfaq.de

    Friday, January 17, 2014 2:20 PM
  • Yes, it is

    -Brad

    Friday, January 17, 2014 3:15 PM
  • Yes, it is

    I know this will seem like a stupid question but are you sure it is running? What account is it running as?

    Do the SSRS reports work without the subscription?


    http://www.enhansoft.com/

    Friday, January 17, 2014 3:51 PM
  • I am positive - see screenshots below of services on the SQL server:

    Yes, reports work perfectly otherwise... Just cannot subscribe.


    -Brad

    Friday, January 17, 2014 4:37 PM
  • Is your SSRS db attached to CEN, USA or WSUS instances?

    BTW, I'm I reading this right that you have 4 sites attached to 1 SQL server? (CAS, CEN, USA, Site??)


    http://www.enhansoft.com/

    Friday, January 17, 2014 5:53 PM
  • SSRS is attached to SCCMCEN - CEN is Central Admin, USA is the Primary. CAS and SITE are from an old environment I am keeping temporarily only for recovery purposes, disregard them.

    -Brad

    Friday, January 17, 2014 6:30 PM
  • Notice that CEN is not set to automatic. Try setting it to automatic and try your subscription again.

    BTW, I generally don't recommend sharing SQL between sites.


    http://www.enhansoft.com/

    Friday, January 17, 2014 6:36 PM
  • Well - turns out simply rebooting the server fixed it - not sure what was pending or preventing it, but problem resolved for now. False alarm. Thanks for the fast feedback, gentlemen.

    -Brad

    • Marked as answer by Brad M Laszlo Friday, January 17, 2014 9:32 PM
    Friday, January 17, 2014 9:32 PM