none
Local instances: Agent service does not work

    Question

  • Hi there,

    In my 2010 laptop got as pending these ones:

    SQL Server 2014 Service Pack 2 GDR (KB3194714)

    SQL Server 2016 RTM GDR (KB3194716)

    Since a month ago or more my system is trying to apply this KB unsuccessfully.

    And today my 2016 instance does not start and SQL Agent for both 2014 and 2016 fails with this message:

    "The service did not start due to a logon failure"

    do you think it is related to with this KB?

    Thanks for your time,

    Monday, November 14, 2016 11:29 AM

Answers

  • Can you change the account using the services applet to the local system account and restart it?
    • Marked as answer by VidhyaSagarModerator Monday, November 14, 2016 12:27 PM
    • Unmarked as answer by Enric Vives Monday, November 14, 2016 12:49 PM
    • Marked as answer by Enric Vives Monday, November 14, 2016 12:49 PM
    Monday, November 14, 2016 11:30 AM

All replies

  • Can you change the account using the services applet to the local system account and restart it?
    • Marked as answer by VidhyaSagarModerator Monday, November 14, 2016 12:27 PM
    • Unmarked as answer by Enric Vives Monday, November 14, 2016 12:49 PM
    • Marked as answer by Enric Vives Monday, November 14, 2016 12:49 PM
    Monday, November 14, 2016 11:30 AM
  • hello Hilary, yes, now my 2016 instance fully operational back but using local system account
    Monday, November 14, 2016 11:58 AM