This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2022 (16.x)
This article describes requirements, limitations and known issues for SQL Server 2022 (16.x).
For hardware and software requirements, see SQL Server 2022: Hardware and software requirements.
This section identifies known issues you may experience with this product. You may also review the Known Issues section of the Cumulative Update articles.
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.
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.
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.
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.
/PolyBaseJava/SQL_INST_MR/SQL_INST_JAVA/SQL_INST_MPY/SQLJAVADIR/SQL_SHARED_MPY/SNAC_SDK/SQL_SHARED_MR/SDK/DREPLAY_CTLR/TOOLS/DREPLAY_CLTWhen 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 is available for preview. It isn't available for use in production environments.
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.
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
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).
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.
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.
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.
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.
Applies to: SQL Server 2022 (16.x) databases that originated from Azure SQL Managed Instance
You may see the following error when you run the DBCC CHECKDB command on a SQL Server 2022 (16.x) database after you delete an index, or a table with an index, and the database originated from Azure SQL Managed Instance, such as after restoring a backup file, or from the Managed Instance link feature:
_Msg 8992, Level 16, State 1, Line <Line_Number>an
Check Catalog Msg 3853, State 1: Attribute (%ls) of row (%ls) in sys.sysrowsetrefs does not have a matching row (%ls) in sys.indexes._
To work around the issue, first drop the index, or the table with the index, from the source database in Azure SQL Managed Instance, and then restore, or link, the database to SQL Server 2022 (16.x) again. If recreating the database from the source Azure SQL Managed Instance isn't possible, please contact Microsoft support to help resolve this issue.
| Preview build | Version number | Date |
|---|---|---|
| General release to market (RTM) | 16.0.1000.6 | November 16, 2022 |
| RC 1 | 16.0.950.9 | September 22, 2022 |
| RC 0 | 16.0.900.6 | August 23, 2022 |
| CTP 2.1 | 16.0.700.4 | July 27, 2022 |
| CTP 2.0 | 16.0.600.9 | May 20, 2022 |
Documentation
Upgrade SQL Server - SQL Server
This article provides links to resources that contain upgrade information for instances of different versions of SQL Server.
SQL Server 2017 Release Notes - SQL Server
This article describes limitations and issues with SQL Server 2017 and provides links to related information.
Editions and supported features of SQL Server 2019 - SQL Server
Editions and supported features of SQL Server 2019
Training
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.