Patch tracker / KB5040942
KB5040942: Microsoft SQL Server 2017 for x64-base Security Update (July 2024)
KB5040942 is a High security update for Microsoft SQL Server 2017 for x64-base, released 2024-07-09. It closes 36 CVEs with a maximum CVSS of 8.8. Get it from the Microsoft Update Catalog below, and see where it sits against the rest of the month on the patch tracker.
Microsoft security update released 2024-07-09. Fixes 36 CVEs.
No exploitation is confirmed for the CVEs in this update and the EPSS exploitation probability is currently 1.8%. That can change: CVEs from past updates regularly get exploited months later, which is why deploying on your normal cadence, without exceptions that linger, is what keeps this one boring.
SQL Server updates deploy per instance, usually via the downloaded package or your server patching tool rather than client update rings. The install guidance below covers the options. For the bigger picture: how the Microsoft patching tools fit together, this month's Patch Tuesday summary, and every update ranked by real-world risk.
Updated July 25, 2026. Data refreshed on every build from MSRC, CISA KEV, and FIRST EPSS.
Download KB5040942
Get the official update for KB5040942. The download and file size for each supported product are on the Microsoft Update Catalog page.
Update summary
Senserva AI Opinion for KB5040942
KB5040942 is the July 2024 GDR rollup for SQL Server 2016 SP3, 2017, and 2019, closing 36 CVEs at a highest Severity of High with a CVSS of 8.8. Most of these are SQL Server engine flaws (for example CVE-2024-38088 and CVE-2024-37318), so any host running a database instance under these versions is in scope. None are on the CISA KEV list and EPSS tops out at 2%, meaning there is no evidence of active exploitation yet, but the count of 36 fixes makes this a substantial single-shot patch.
Do this: Schedule the GDR update across your SQL Server 2016 SP3, 2017, and 2019 instances during your next maintenance window, prioritizing internet-facing or business-critical database hosts first.
AI-generated from public data, 2026-07-21. Verify against the vendor advisory before acting.
Senserva AI Opinion and rich prompt for KB5040942
Copy this prompt into Claude, ChatGPT, or Copilot. The facts are included, sourced from this page.
Full tracking and change history for KB5040942
Senserva began recording day-to-day change history on 2026-07-07, and refreshes it several times a day. Release dates are historical where Microsoft publishes them; revision history is tracked from that date forward, so it does not include changes made before then.
Exploitation and severity
Fixes 36 CVEs. Most severe CVSS 8.8 (High). EPSS exploit probability up to 1.8%.
Among the lower half of tracked Microsoft updates by EPSS exploit probability.
What to do
Moderate priority: schedule it in your normal patch cycle. Senserva flags whether KB5040942 is missing on your devices.
Check if KB5040942 is installed
Copy-paste PowerShell: one machine, or your whole fleet in one pass. No output means the update is not installed.
Get-HotFix covers Windows updates. Office, SharePoint, and Exchange server updates show under installed updates in Programs and Features, or check the Update Catalog history.
Writing about KB5040942? Cite this page
Copy-paste for a blog post, forum answer, or internal doc. The link always carries the current risk data.
CVEs fixed by this update
Sorted exploited-first, then by CVSS. Every CVE links to its Senserva page with the full risk facts, references, and a ready-to-paste AI prompt.
Affected products
Also released in July 2024
The highest-risk updates from the same release:
The full month, summarized: Microsoft Patch Tuesday.
How to install KB5040942
This is a SQL Server update. It deploys per instance:
- Manual or scripted install of the package from the Update Catalog above, instance by instance, starting with test.
- Microsoft Update can offer SQL Server updates when the machine opts in to updates for other Microsoft products.
- Verify afterward by checking the instance build number against the update's target build.
Common questions about KB5040942
Is KB5040942 urgent?
KB5040942 is rated High. Include it in your normal patch cycle unless your environment raises its priority.
How do I download KB5040942?
From the Microsoft Update Catalog (linked on this page), or let Intune, Windows Update for Business, Windows Autopatch, or WSUS deliver it. The catalog page lists the download for each supported product.
How do I deploy KB5040942 with Intune?
Assign a Windows Update ring (quality update policy) to the device groups and the update flows on the ring's deferral schedule. For urgent updates, Intune expedite policies can bypass the ring deferrals. Verify the rollout with update compliance reporting rather than assuming delivery.
Can I ask my own AI about KB5040942?
Yes. This page includes a free, ready-to-paste AI prompt containing KB5040942's key facts: severity, CVE count, exploitation status, and the download link. Copy it into Claude, ChatGPT, or Copilot for a rollout plan; the data is refreshed twice a day (5 AM and 3 PM US Central).
Authoritative references
See this and every Microsoft update ranked by real-world risk on the Microsoft Patch Tracker.
