Microsoft has recently rolled out a new out-of-band update for Windows Server to tackle SQL-related problems that have surfaced following the installation of the June 2024 Patch Tuesday updates. The issue specifically pertains to Azure Synapse SQL and is impacting Windows Server 2022, Windows Server 23H2, as well as Azure Stack HCI 23H2/22H2.
According to a post on the Windows Message Center, the problem manifests as Azure Synapse SQL Serverless Pool databases entering a "Recovery pending" state. In response to this issue, Microsoft has taken swift action to provide a resolution. The issue arises post the installation of the June 2024 Windows security update on Windows Server 2022 (KB5039227), Windows Server version 23H2 (KB5039236), and Azure Stack HCI versions 23H2 and 22H2 (KB5039227).
KB5041054: The Fix
Currently, the fix in the form of KB5041054 is accessible for Windows Server 2022 and Azure Stack HCI 22H2. Updates for the remaining platforms will be made available in forthcoming Windows Updates. Below is the official changelog for KB5041054:
- This update addresses a known issue affecting the BCryptSignHash API, where the API returns “STATUSINVALIDPARAMETER” due to the usage of NULL padding input parameters for RSA signatures. This issue is more likely to occur when Customer-Managed Keys (CMK) are utilized, such as in an Azure Synapse dedicated SQL pool.
KB5041054 can be found exclusively in the Microsoft Update Catalog. Being a cumulative update (requiring a restart), there is no necessity to apply previous updates before installing KB5041054. Microsoft advises systems yet to install the June 2024 Patch Tuesday updates to first apply KB5041054.
It is important to note that the issue does not impact regular home users with Windows 10 and 11 Home or Professional editions. Nonetheless, these users should remain vigilant of a few confirmed issues, including jumplist bugs and challenges when updating from Windows 10 Professional to Enterprise.
For further details on KB5041054, refer to the official documentation provided by Microsoft.