Share via

Updating SQL Server with Windows Update

knt1N 286 Reputation points
2021-09-24T09:56:22.787+00:00

I'm using SQL Server 2017 Standard.
In the wizard window when installing it, when "Include SQL Server product updates" was set to ON and installed, the GDR update was installed by Windows Update.

This setting does not install CU updates.
The CU update that was manually downloaded from the Microsoft Update Catalog was able to be installed without any problems.

Can I change this "Include SQL Server product updates" setting after the installation is complete?
What I mean is a change, such as switching the update to be installed between GDR and CU, or turning automatic updates on/off with Windows Update.

(I'm inexperienced with SQL Server updates and it's hard to understand by reading Microsoft documentation, so I might be asking strange questions...)

==================================================

It seems that only GDR is downloaded in Windows Update.
I'm going to use Windows Update on a DB server that uses GDR updates and manually download them from the Microsoft Update Catalog for DB servers that use CU updates.

I would like to continue to ask questions about how to turn the "Include SQL Server product updates" setting on/off after installation is complete.

SQL Server Other
0 comments
Accepted answer
  1. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    2021-09-27T03:19:14.74+00:00

    Hi kent1N-9820,

    I would like to continue to ask questions about how to turn the "Include SQL Server product updates" setting on/off after installation is complete.

    There is no longer need to turn off “Include SQL Server product updates” in the Product Updates page of installation wizard after the installation is complete. The "Include SQL Server product updates" in the "Product Updates" page of the installation wizard will not affect subsequent updates after installation.
    When “Include SQL Server product updates” is selected during installing the SQL Server, the latest available SQL Server product updates are displayed. If you don't want to include the updates during installation, clear the Include SQL Server product updates check box.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2021-09-24T22:09:58.487+00:00

    I don't think CUs are fed through Windows Update. Only the GDRs are.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.