SQL Server 2022 release notes

Applies to: SQL Server 2022 (16.x)

This article describes requirements, limitations and known issues for SQL Server 2022 (16.x).

Hardware and software requirements

For hardware and software requirements, see SQL Server 2022: Hardware and software requirements.

Known issues

This section identifies known issues you may experience with this product. You may also review the Known Issues section of the Cumulative Update articles.

SQL Setup

Help

When you run setup /HELP, the information returned doesn't include the new /AZUREEXTENSION feature. Complete information for Setup is available at Install SQL Server on Windows from the command prompt.

Localized language interface

In certain localized languages, the Azure Extension configuration screen controls may be partially overwritten or missing. To resolve this issue, expand or maximize the Setup window from the default window sizing.

Software Assurance installation parameter

A new Setup command line installation parameter /PRODUCTCOVEREDBYSA indicates if the provided product key (/PID=) license is covered under a Software Assurance or SQL Server Subscription contract, or just a SQL Server license.

Install SQL Server on Windows from the command prompt describes this parameter.

Deprecated feature parameters

The following features aren't available in Setup in SQL Server 2022 (16.x). If specified in command line installations or scripts, these previously supported parameters may fail.

Restart requirement

When you install an initial SQL Server 2022 (16.x) instance on a Windows Server 2022 machine, if the computer doesn't have VCRuntime140 version 14.29.30139 or a later version installed, Setup will require a restart.

Windows Server 2022 was released with VCRuntime version 14.28.29914.

Query Store for secondary replicas

Query Store for secondary replicas is available for preview. It isn't available for use in production environments.

Known issues with Parameter Sensitive Plan optimization

If you are using the Parameter Sensitive Plan optimization feature, please review the guidance and mitigation for known issues that can results in exceptions during query store cleanup process. More information and details is available at Access violation exception occurs in Query Store in SQL Server 2022 under certain conditions.

RPC calls fail with Encrypt=Strict

An issue in the TDS 8.0 protocol implementation may cause RPC calls to fail if the Encrypt option is set to Strict in your connection string, for example when running the sp_who system stored procedure.

Applies to: SQL Server 2022 (16.x) RTM

Availability group replica manager

Error 35221 states that the Always On availability groups replica manager is disabled. This error may be encountered when attempting to add a file to a FILESTREAM filegroup or a memory-optimized filegroup, or when attempting to add additional transaction log files to a database.

Applies to: SQL Server 2022 (16.x) RTM

The fix for this issue is released in Cumulative Update 1 for SQL Server 2022 (16.x).

To work around this issue, you can use Trace Flag 12324 as either as startup trace flag, or at the session level (using DBCC TRACEON).

SQL Server Agent errors when using contained Availability Group

You might encounter error messages in SQL Server Agent or Database Mail when using contained Availability Group feature of SQL Server 2022 (16.x).

Review the article Errors occur after you apply a cumulative update to an instance of SQL Server that has a contained availability group for details on addressing the issue.

SQL Server services are set to Automatic (Delayed Start) start mode

In SQL Server 2022 (16.x), setting the Start Mode for a SQL Server service to Automatic in Configuration Manager, will configure that service to start in Automatic (Delayed Start) mode instead, even though the Start Mode shows as Automatic.

MSOLEDBSQL19 and linked servers

Currently, MSOLEDBSQL19 prevents the creation of linked servers without encryption and a trusted certificate (a self-signed certificate is insufficient). If linked servers are required, use the existing supported version of MSOLEDBSQL.

Transaction log growth for databases with In-Memory OLTP

You may notice excessive growth in the transaction log size for databases with the In-Memory OLTP feature enabled. This might be coupled with XTP_CHECKPOINT as log_reuse_wait_desc in sys.databases.

For more information, review Transaction log file grows for databases with In-Memory OLTP in SQL Server 2022.

Build number

Next steps

• What's new in SQL Server 2022 (16.x).