How to configure automated updates?

Question

Post reply

How to configure automated updates?

tarr94

SSCommitted

Points: 1684
More actions
May 9, 2019 at 3:01 pm

#3639141
Hi,
My company recently (a couple months ago) migrated a particular application to a new Windows Server 2016 box with SQL Server 2016. As I review the event logs and SQL logs from last night, it appears that updates to SQL Server 2016 Database Engine Services and Full text Search tried to install, but failed.
My questions are:
1. Are these updates automated?
2. If so, are they part of Windows updates or is this is setting that can be altered within SQL Server Management Studio?
Basically, we don't understand why the update triggered, and we'd prefer to manually trigger them ourselves.
Greatly appreciate any assistance on this.
- This topic was modified 5 years, 7 months ago by tarr94.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Alejandro Santana SSCommitted Points: 1838 More actions · Answer 1

Hello,

Windows Updates are automatic unless they require the server reboot, it'll ask you for a time to restart the server.
Yes they might be part of windows updates, no you can't alter them through SSMS, you have to disable Windows Updates through windows OS.

The normal process is to download on your own CU,SP's from Microsoft or just install WSUS and manage your Active Directory computers/servers updates through the service.

Windows update will install whenever they can, its best to disable it to not interrupt your company services and install the updates on your own, of course, after testing in a QA environment.

Also, i think CU's and SP's updates are optional and not important(Talking about Windows Update levels, not that SQL Server updates are not important, they are VERY VERY important), I think Windows Update would not install optional updates without an end user doing it manually unless of course the updates are fixing important security issues that might cause harm to your company.

Greetings.