Views
262

Your rating
Rate update installation process

Log in to rate this update.
Login

Risk factor
No ratings yet. Be the first to rate this update.

Smooth installs 0%
Minor issues 0%
Major issues 0%

AI enhanced content

Update Summary

KB5104822 updates Microsoft SQL Server 2025 to version 17.0.4075.5. It includes 11 fixes, adds encryption support for PolyBase gRPC communication on Linux, and introduces a new optional `@multi_subnet_failover` parameter to `sp_adddistributor`.

Update Details

Security

  • Enable encryption with Extended Protection to help secure SQL Server on Windows.
  • Fixes include security-relevant hardening for communication between the PolyBase external service and gRPC clients on Linux.

Bug Fixes

  • Restoring a database with VSS and WITH MOVE can be slow or time out on servers with many databases.
  • An index rebuild maintenance plan can stop responding because of a long-running query.
  • SQL Server Setup may recommend 128 GB max server memory instead of 256 GB for Standard and Standard Developer editions.
  • Changing collation during initial setup can block mssql-conf unexpectedly on high-CPU Linux systems.
  • OPENJSON can return unexpected rows when a JSON path contains special pattern-matching characters.
  • DBCC CHECKTABLE with EXTENDED_LOGICAL_CHECKS can assert and dump for persisted computed columns using native json.
  • JSON_MODIFY can fail with errors 13643, 7102, or 13647 when working with large native json arrays.

New Features

  • Adds encryption support for communication between the PolyBase external service and gRPC clients on Linux.
  • Adds a new optional parameter, @multi_subnet_failover, to sp_adddistributor.

Known Issues

  • SESSION_CONTEXT in parallel plans can return incorrect results or cause access violation dump files, especially when a session is reset for reuse.
  • Linked server queries that use MSDASQL with a provider string can fail with error 7416 due to stricter connection validation.
  • Queries against sys.dm_exec_requests during database recovery can raise an access violation and dump file.
  • Mitigation for the recovery-related access violation includes enabling trace flag 4696, avoiding sys.dm_exec_requests queries on recovering databases, or uninstalling the update.

Hints

  • A downloadable Excel workbook provides build summaries and detailed fix lists for SQL Server 2025, 2022, 2019, and 2017.
  • Bug reference IDs in the fix table can be used as URL bookmarks in the #NNNNNNN format.
  • This update includes components for SQL Server Engine and Analysis Services; the target build is 17.0.4075.5.

Product Information

Vendor: Microsoft

Product: SQL Server

Product type: Software

Variant: SQL Server 2025

Version: 17.0.4075.5

Vendor information published: Aug 13, 2026

Original release notes: View on vendor site

Published on updatealert.io: Sep 29, 2026