[German]On July 9, 2024, Microsoft also released the update KB5040711 (Security Update for Microsoft OLE DB Driver for SQL Server). However, I have received a reader report that an installation error occurs during the update installation. There are also reader reports of "hiccups" during the installation of SQL Server updates under Windows Server. Here is a quick overview of what has been reported to me – however, the errors do not appear to be widespread.
Advertising
SQL server updates
For the patchday on July 9, 2024, Microsoft had to release a number of updates for its SQL servers. In the article Microsoft Security Update Summary (July 9, 2024) I had pointed out that 38 CVEs (details here) affecting Remote Code Execution vulnerabilities (all CVEv3 score 8.8) for Microsoft OLE DB Driver and SQL Server Native Client OLE DB Provider have been closed by updates.
Installation error 0x80070643
German blog reader Patrick F. had already contacted me by email on July 11, 2024. When trying to install the Security Update for Microsoft OLE DB Driver for SQL Server (KB5040711), he receives the error 0x80070643 on one of his three database servers and the installation is aborted.
In the blog post Microsoft's PowerShell script against installation error 0x80070643 for KB5034441 (Jan. 2024) I wrote something about error 0x80070643 in a different context. The error code stands for:
0x80070643 – ERROR_INSTALL_FAILURE
a rather generic error. If nothing else is reported, analyzing the cause is likely to be rather difficult – especially since only one of three servers throws the error. It may be related to a .NET framework package – and perhaps the CBS.log will provide clues after you have checked the system with sfc /scannow. Anyone else with this error?
WSUS download error during update KB5040712
Bernie reported in this comment that there was a download error when downloading the security update for Microsoft OLE DB Driver 19 for SQL Server (KB5040712) from WSUS. The security update for Microsoft OLE DB Driver for SQL Server (KB5040711) was downloaded via WSUS without any problems.
Advertising
Bump in the SQL update
Otherwise there is this comment in the blog, the note that the Windows Update for Windows Server 2016 is only installed after the first reboot. SQL is installed on the server and the system requires two reboots accordingly.
In this comment Adrian wrote, that "SQL 2017 and 2019 also struggled at first" – there was a download error. But the updates went through in the end or after a restart.
Similar articles:
Microsoft Security Update Summary (July 9, 2024)
Patchday: Windows 10/Server Updates (July 9, 2024)
Patchday: Windows 11/Server 2022-Updates (July 9, 2024)
Windows Server 2012 / R2 und Windows 7 (July 9, 2024)
Microsoft Office Updates (July 9, 2024)
Windows 11 update KB5040442 causes issues with Outlook 2021
Windows July 2024 updates break remote connections
Windows 10/11 updates (e.g. KB5040442) trigger Bitlocker queries (July 2024)
Windows Update July 2024: Are there issues with Radius authentications?
July 2024 security update KB5040427 crashes Windows 10/Server LPD printing service
Microsoft's fixes for various Windows bugs (July 2024)
Advertising
Good afternoon,
I had a very similar situation today. As per protocol, in these cases I always try the manual installation.
It doesn't always work, but I usually get more specific error messages.
In this case you can get the drivers at Release notes for the Microsoft OLE DB Driver for SQL Server (https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16).
I did that and when I ran the installer manually, the error reported was the absence of the VS 2022 Visual C++ Redistributable. I downloaded it from https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170 and then instead of retrying the manual install, (just to test) I did it from windows update and it worked perfectly.
Best regards;
O'Lach
Translated with DeepL.com (free version)
There is another fact to complain – Microsoft has published an update that had sort of bypass update to the OS driver "SQL SERVER" to accept TLS 1.2 and force certificate checking. This update was not rolled out to Server 2016 altohough it has NOT reached end of life.
When we introduced TLS 1.2 some years ago we noted that the driver sQL SERVER could not handle this for the time being in Server 2019 but in November 2022 suddenly the TLS 1.2 problem (SSL security error) disappeared.
Does anybody know how to update that driver in Windows Server 2016?