Automatic startup of SQL server when configured with SCCM.

Sathis Babu 0 Reputation points
2024-07-01T13:52:21.2366667+00:00

I have configured SCCM with a remote SQL server in the same domain, and it is working fine.

When I stop the SQL server in the remote machine, it gets started automatically in a few minutes. I want to know who is responsible for automatically starting the SQL Server after manually stopping it. Before configuring SCCM server with that SQL instance, it never happened.

I have disabled the SQL Server Agent automatic restart of SQL server, so it can't be responsible.
Screenshot (4)

Also I have not setup any recovery actions in services also User's image I also tried to check in taskschd.msc, don't have a clue on how to check this, attaching a screenshot for reference.

User's image

I want to know if SCCM is responsible for this behaviour(if so, how can I confirm that), or any scheduler or something is configured(automatically in the backend like a scheduler) in SQL server machine itself during the configuration of SCCM server.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,216 questions
Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sherry Kissinger 4,136 Reputation points
    2024-07-01T20:59:20.5333333+00:00

    My guess is that SMSExec or Hierarchy Manager , components of CM, are restarting SQL if stopped. There are logs for that in <installed location>\Logs, smsexec.log, or hman.log. I believe (but don't know, check the documentation), that "about every 15 minutes", a health check is done.

    I think the better question is why you are stopping SQL when CM wants/needs it to be there? If you need to do maintenance on the SQL instance, either also stop the SMS services (and restart them after SQL is back), or look into the high availability options for sql that CM can leverage:

    https://video2.skills-academy.com/en-us/mem/configmgr/core/servers/deploy/configure/high-availability-options

  2. AllenLiu-MSFT 42,436 Reputation points Microsoft Vendor
    2024-07-02T06:58:03.29+00:00

    Hi, @Sathis Babu

    Thank you for posting in Microsoft Q&A forum.

    I think automatic startup of SQL server is triggered by SQL Server itself.

    You may check the limitations and restrictions for Auto Restart to function properly.

    https://video2.skills-academy.com/en-us/sql/ssms/agent/autorestart-sql-server-agent-sql-server-management-studio?view=sql-server-ver16#BeforeYouBegin

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".