Sample Header Ad - 728x90

Automatic startup of SQL server when configured with SCCM - Who is responsible?

0 votes
0 answers
40 views
I have configured SCCM with a remote SQL server in the same domain, and it is working fine. When I stop the SMS_EXECUTIVE service fo SCCM and SQL server in the remote machine, SQL server 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. Image Also I have not setup any recovery actions in services too Image I also tried to check in taskschd.msc, don't have a clue on how to check this, attaching a screenshot for reference. 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.
Asked by Sathis babu (1 rep)
Jul 4, 2024, 08:13 AM