Share via

I want to know the reason why SQL Server restarted the service without permission

村田 亮太 40 Reputation points
2023-11-07T09:14:00.9833333+00:00 
○事象
Hyper-V環境の仮想サーバにてSQLServer関連のサービス(下記参照)が勝手に停止し、2,3分後に勝手に開始した
・fdlauncher.exe
・fdhost.exe
・sqlwriter.exe
・SQLAGENT.EXE
・Sqlservr.exe

○環境
OS:Windows Server 2019 R2
SQLServer:Microsoft SQL Server 2019 Standard (64bit)
          SQL Server Management Studio (SSMS) 18.11.1

○考えられる原因
時間を見るとWindowsUpdateにて「SQL Server 2019 RTM GDR のセキュリティ更新プログラム(KB5029377)」のインストールをした後、サービス再起動が発生したようです。
関係はございますでしょうか。

English translation is next to the question in Japanese.

○Event
SQLServer-related services (see below) stopped automatically on a virtual server in a Hyper-V environment, and started automatically after a few minutes.
・fdlauncher.exe
・fdhost.exe
・sqlwriter.exe
・SQLAGENT.EXE
・Sqlservr.exe

○Environment
OS:Windows Server 2019 R2
SQLServer:Microsoft SQL Server 2019 Standard (64bit)
           SQL Server Management Studio (SSMS) 18.11.1

○Possible causes
Looking at the time, it seems that the service restarted after installing the "SQL Server 2019 RTM GDR security update (KB5029377)" using Windows Update.
Is there any relationship?
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,361 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,636 questions
Accepted answer
  1. Erland Sommarskog 107.2K Reputation points
    2023-11-07T22:36:45.17+00:00

    Installing a GDR will indeed require SQL Server to be restarted, since the SQL Server Executable is replaced.

    I note that you have the RTM build of SQL 2019. I would strongly recommend that you download and install the more recent Cumulative Update to get access to many enhancements and bug fixes. And, yes, that installation will require a restart of SQL Server.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-11-08T02:32:12.07+00:00

    Hi @村田 亮太

    Possible causes Looking at the time, it seems that the service restarted after installing the "SQL Server 2019 RTM GDR security update (KB5029377)" using Windows Update. Is there any relationship?

    Yes, there is.

    You can refer to Description of the security update for SQL Server 2019 GDR.

    https://support.microsoft.com/en-us/topic/kb5029377-description-of-the-security-update-for-sql-server-2019-gdr-october-10-2023-a646537e-adbc-44e1-9bbb-5508ad35b03b

    Best regards,

    Percy Tang