KB5041321 - Cumulative Update 15 for SQL Server 2022

KB5041321 - Cumulative Update 15 for SQL Server 2022

Improvements and fixes included in this update

3285880
Fixes a domain account authentication issue in the configuration tool by adding an auto-retry method to the account validation part, which will use the UPN format and try to authenticate using three separate authentication methods after the authentication fails in SAM format and default.

3354272
Updates the criterion for determining the current machine type and the judgment conditions of whether it is a domain controller.

3459086
Fixes an issue in which the SQL Server Volume Shadow Copy Service (VSS) Writer can't freeze the database during a VSS-based backup. For more information, see known issue two of SQL Server 2022 CU14.

3287656
Fixes an assertion failure (Location: ListenerSpec.cpp:480; Expression: totalUsed + cbListenerName

3301982
Fixes an assertion failure (Location: MetadataVersion.cpp:71; Expression: !CFeatureSwitchesMin::GetCurrentInstance()->FEntityVerStoreCsnCheckEnabled() || newInfo != InvalidXts()) that you encounter when you try to change the database owner on a readable secondary replica of an Always On availability group.

3338395
Fixes an issue in which PolyBase throws the following error at service startup if the SQL Server instance is configured to listen on multiple TCP ports:

System.ArgumentException: Unable to parse port, instance = '<instancename>', text = '<text>'

3101865
Adds a validation for the MODEL parameter when running PREDICT to avoid errors due to the input of wrong models.

3181615
Adds a new security feature to implement change data capture (CDC) metadata data definition language (DDL) lockdown, preventing errors that might occur when running sp_cdc_vupgrade against a database with CDC disabled.

3338274
Fixes the following error 21890 that you encounter when you use the case-sensitive collation and run sp_validate_redirected_publisher:

The SQL Server instance '<instancename>' with distributor '<distributorname>' and distribution database '<databasename>' cannot be used with publisher database '<databasename>'. Reconfigure the publisher to make use of distributor '<distributorname>' and distribution database '<databasename>'.

3362871
Fixes an issue with checkpoint operation in which the following error 2601 occurs when SQL Server tries to perform a checkpoint operation on the database that has change tracking enabled:

<datetime> Error: 2601, Severity: 14, State: 1.
<datetime> Cannot insert duplicate key row in object '<objectname>' with unique index '<indexname>'. The duplicate key value is <keyvalue>.

3394373
Fixes an issue in which error 18752 occurs and transactional replication stops working when you use a heavy workload in combination with availability groups and after a failover occurs.

Error message:

Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection with session ID <sessionid> over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure.

3325413
Before the fix, the SQL Server error log records many messages regarding starting or stopping Extended Events (XEvents) sessions. After applying the fix, starting or stopping XEvents sessions isn't logged by default. You can enable it by turning trace flag 9714 on.

3409327
Fixes an issue in which table and column names that are read from database metadata aren't correctly quoted in some cases when building internal SQL Server batches in stored procedures that manage temporal tables. After applying the fix, quoting is completed correctly.

2862558
Fixes the slowness of RESTORE WITH STANDBY operations that you encounter when accelerated database recovery (ADR) isn't enabled.