Patch tracker / KB5040946
KB5040946: Microsoft SQL Server 2017 for x64-base Security Update (July 2024)
KB5040946 is a High security update for Microsoft SQL Server 2017 for x64-base, released 2024-07-09. It closes 37 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 37 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 KB5040946
Get the official update for KB5040946. The download and file size for each supported product are on the Microsoft Update Catalog page.
Update summary
Senserva AI Opinion for KB5040946
37 CVEs are closed in this SQL Server 2016, 2017, and 2019 update, including CVE-2024-38088 and CVE-2024-38087, the highest reaching Severity High at CVSS 8.8. This is one of several sibling packages from the same July rollup with slightly different CVE counts depending on edition and servicing branch. Treat it as a major update requiring careful change control given its scope.
Do this: Apply this large SQL Server rollup through normal change control, verifying the 37-CVE count matches your servicing branch.
AI-generated from public data, 2026-07-07. Verify against the vendor advisory before acting.
Senserva AI Opinion and rich prompt for KB5040946
Copy this prompt into Claude, ChatGPT, or Copilot. The facts are included, sourced from this page.
Full tracking and change history for KB5040946
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 37 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 KB5040946 is missing on your devices.
Check if KB5040946 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 KB5040946? 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 KB5040946
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 KB5040946
Is KB5040946 urgent?
KB5040946 is rated High. Include it in your normal patch cycle unless your environment raises its priority.
How do I download KB5040946?
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 KB5040946 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 KB5040946?
Yes. This page includes a free, ready-to-paste AI prompt containing KB5040946'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.