Skip to content

sql-server-2022-release-notes.md

Latest commit

 

History

History
87 lines (59 loc) · 3.75 KB

sql-server-2022-release-notes.md

File metadata and controls

87 lines (59 loc) · 3.75 KB
title SQL Server 2022 Release Notes
description Find information about SQL Server 2022 (16.x) limitations, known issues, help resources, and other release notes.
ms.date 11/01/2022
ms.prod sql
ms.reviewer
ms.technology release-landing
ms.topic article
ms.custom
event-tier1-build-2022
author MikeRayMSFT
ms.author mikeray
monikerRange = sql-server-ver16

[!INCLUDESQL Server 2022] release notes

[!INCLUDESQL Server 2022]

This article describes requirements, limitations and known issues for [!INCLUDESQL Server 2022].

Complete details about licensing are in License Terms folder on the installation media.

Hardware and software requirements

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

Feature notes

This section identifies known issues you may experience with this product.

SQL Setup

Help

When you execute setup /HELP the information returned does not include the new /AZUREEXTENSION feature. Complete information about the features available in setup are 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 issue, expand or maximize the Setup window from the default window sizing. This will be resolved in Cumulative Update 1 (CU 1) and later. If you install a SQL Server 2022 instance as a Slipstream installation (/UPDATESOURCE=) with CU 1 or later, this issue will not be present.

Software Assurance installation parameter

There is a new Setup command line installation parameter - /PRODUCTCOVERDBYSA. The parameter 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 are not available in Setup in SQL Server 2022. 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_CLT

Reboot requirement

When installing an initial SQL Server 2022 instance on a Windows Server 2022 machine, if the server does not have VCRuntime140 version 14.29.30139 or later installed, Setup will require reboot.

Windows Server 2022 was released with VCRuntime version 14.28.29914.

You can avoid the reboot requirement. Before you install the initial SQL Server 2022 instance on Windows Server 2022, download and install the current VCRuntime140 (14.32.31332) at https://aka.ms/vs/17/release/vc_redist.x64.exe.

Build number

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

Next steps

For related information about new features and capabilities in this version of SQL Server, see:

[What's new in [!INCLUDEsql-server-2022]](what-s-new-in-sql-server-2022.md).