Database server reboot automatically after manual updates

Question

We are using Microsoft Server 2019 standard and SQL server 2019.

Last night I pushed updates on SQL Database server but did not reboot it.

In the morning I was surprised to see that server get restarted after installing Windows updates.

Nothing is defined in Task Scheduler and I checked the Group policy and only option 2 was selected to Download and Notify and not to reboot any server under policy.

I am not too sure if manually downloading OS updates made a mess and triggered the Auto restart

Could anyone tell me the possible reason? or what I need to check to avoid this?

Is there any settings that need to change on SQL Database server to stop from happening this?

Answer 1

Hi @RD，

As far as I known, restarting Windows will mean restarting all the services running on it including SQL Server.

To prevent automatic startup of an instance of SQL Server, you may follow the steps.

On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.

In SQL Server Configuration Manager, expand Services, and then click SQL Server.

In the details pane, right-click MSSQLServer, and then click Properties.

In the SQL Server <instancename> Properties dialog box, on the Service tab, in the General box, set the value of Start Mode to Manual.

1. Click OK to close the SQL Server <instancename> Properties dialog box, and then close SQL Server Configuration Manager.

Check: SCM Services - Prevent Automatic Startup of an Instance

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.