Skip to the content
The Update Bureau

SQL Server 2022 · Release Health

Known issues in SQL Server 2022

Problems Microsoft has confirmed for this version, from its official release health notes. 7 still open or mitigated.

Active known issues

Open & Mitigated
7 active issues
  1. Open SQL Server 2022 Affects: Organizations and IT administrators Started with KB5104824 · Sep 15, 2026

    Some Master Data Services features might not work as expected

    After installing KB5104824, creating an entity or attribute in Master Data Services, or loading hierarchies in Explorer, might not work as expected.

    Workaround status No workaround yet

    Microsoft has not published a manual workaround for this issue yet. Defer KB5104824 on affected systems until a fix is released.

  2. Open SQL Server 2022 2025 Affects: Organizations and IT administrators Started with KB5093420 · Jul 16, 2026

    Access violation when you query sys.dm_exec_requests during database recovery

    Queries against sys.dm_exec_requests might cause an access violation and create a dump file while a database is recovering. This can happen during restore, startup recovery, or before an availability group replica comes online.

    How to apply the workaround SQL Trace Flag

    Enable trace flag 4696, avoid queries against recovering databases, or uninstall the update. With the trace flag, monitoring queries on secondary replicas might return errors 976 or 978.

    Step-by-step workaround instructions
    2 steps
    Show steps Hide steps
    Step-by-step procedure
    1. Enable trace flag 4696 to opt out of the code change.
    2. Alternatively, avoid queries against sys.dm_exec_requests for databases that are recovering, or uninstall the update.
  3. Open SQL Server 2022 Affects: Organizations and IT administrators Started with KB5080999 · Mar 12, 2026

    Availability group listener error 10013 in error log

    When the SQL Server service starts or an availability group fails over, listener-related errors might appear in the error log. Creating a listener might also produce an error that its TCP port is already in use. The messages do not affect functionality, and listener connections continue to work.

    Workaround status No workaround yet

    Microsoft has not published a manual workaround for this issue yet. Defer KB5080999 on affected systems until a fix is released.

  4. Open SQL Server 2016 2017 2019 2022 2025 Affects: Everyone Started with KB5080999 · Mar 12, 2026

    Linked server queries that use MSDASQL fail with error 7416

    Linked-server queries using the MSDASQL provider and a provider string might fail with error 7416, reporting that no login mapping exists. The Database Engine's stricter connection validation can reject certain configurations that worked in earlier builds.

    How to apply the workaround Workaround

    Use the workaround guidance in the linked Microsoft troubleshooting article.

  5. Open SQL Server 2016 2017 2019 2022 Affects: Organizations and IT administrators Started with KB5042207 · Sep 10, 2024

    CDC capture job might fail if columns are missing in CDC change tables

    On databases using change data capture (CDC), columns with commas in their names might be missing from CDC tracking tables and cause capture-job failures; a comma-containing column in a tracking table might be dropped during a CDC upgrade. Separately, CDC upgrades can fail when tracking-table column names contain other symbols.

    How to apply the workaround SQL Trace Flag

    Before upgrading the GDR build, enable trace flag T15006 and restart the SQL Server service.

    Step-by-step workaround instructions
    3 steps
    Show steps Hide steps
    Step-by-step procedure
    1. In SQL Server Configuration Manager, open the instance properties and go to the Startup Parameters tab.
    2. Add trace flag T15006, select Add and Apply, then restart the SQL Server service.
    3. Perform the GDR upgrade.
  6. Open SQL Server 2019 2022 Affects: Organizations and IT administrators Started with KB5038325 · Jul 23, 2024

    Issue two: SQL Server VSS Writer might fail to perform a backup because no database is available to freeze

    Backup tools might fail to create application-consistent backups because SQL Server VSS Writer has no database available to freeze. The issue is fixed in CU15.

    How to apply the workaround Workaround

    The page's current solution is to roll back to CU13 and perform the snapshot backup.

    Step-by-step workaround instructions
    2 steps
    Show steps Hide steps
    Step-by-step procedure
    1. Roll back to SQL Server 2022 CU13.
    2. Perform the snapshot backup.
  7. Open SQL Server 2019 2022 2025 Affects: Everyone Started with KB5033688 · Feb 15, 2024

    Incorrect behavior of SESSION_CONTEXT in parallel plans

    Queries using SESSION_CONTEXT might return wrong results or create access violation dump files when they run in parallel query plans, especially if a session is reset for reuse.

    Workaround status No workaround yet

    Microsoft has not published a manual workaround for this issue yet. Defer KB5033688 on affected systems until a fix is released.

Recently resolved

Fixed in latest updates
2 resolved
  1. Resolved SQL Server 2019 2022 Affects: Organizations and IT administrators Started with KB5037331 · Jun 13, 2024 Fixed by KB5037331

    Issue three: Patching error for secondary replicas in an availability group with databases enabled replication or CDC

    Setup can initially fail when patching an availability group database with replication or CDC enabled because the catalog upgrade scripts cannot access the database in single-user mode. SQL Server starts again without single-user mode and completes patching; CU16 fixes this issue.

    How to apply the workaround SQL Trace Flag

    Before running the patch, enable Trace Flag 12347 and remove it after patching, or remove the affected database from the availability group or remove CDC or replication from that database.

    Step-by-step workaround instructions
    4 steps
    Show steps Hide steps
    Step-by-step procedure
    1. Before running the patch, choose one of the following options.
    2. Enable Trace Flag 12347, then remove it after patching.
    3. Drop the CDC- or replication-enabled database from the availability group.
    4. Remove CDC or replication from the database in the availability group.
  2. Resolved SQL Server 2022 Affects: Organizations and IT administrators Started with KB5032679 · Jan 11, 2024 Fixed by KB5031778

    Issue one: Read-scale availability group not displayed in dm_hadr_database_replica_cluster_states

    A CU10 fix caused the Availability Databases folder in SQL Server Management Studio not to show databases in read-scale availability groups. This issue is fixed in SQL Server 2022 CU12.

    Resolution Fixed in KB5031778

    Install KB5031778 (or a later cumulative update) on affected devices. No manual workaround is required after updating.

No known issue matches these filters.