SQL Server 2019 (15.x) release notes

THIS TOPIC APPLIES TO:yesSQL Server noAzure SQL DatabasenoAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

This article describes limitations and known issues for the SQL Server 2019 (15.x). For related information, see:

What's New in SQL Server 2019 (15.x)

SQL Server 2019 (15.x)

SQL Server 2019 (15.x) is the latest public release of SQL Server.

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

Documentation

  • Issue and customer impact: SQL Server documentation can be filtered by version. Use the control at the top left of each documentation page to filter for your requirements.

Build number

The RTM build number for SQL Server 2019 is 15.0.2000.5.

SQL Server 2019 servicing updates

For current information about SQL Server servicing updates, see https://support.microsoft.com/help/4517790.

SQL Server installation may fail if SSMS 18.x is installed

  • Issue and customer impact: SQL Server 2019 (15.x) installation fails when the following installations happen in this order:

    1. SQL Server Management Studio (SSMS) version 18.0, 18.1, 18.2, or 18.3 is installed on the server.
    2. SQL Server 2019 (15.x) installation is attempted from removable media. For example, the installation media is a DVD.
  • Workaround:

    1. Uninstall any version of SSMS older than SSMS 18.3.1.
    2. Install a newer version of SSMS (18.3.1 or later). For the latest version, see Download SSMS.
    3. Install SQL Server 2019 (15.x) normally.
  • Applies to: SQL Server 2019 (15.x)

UTF-8 collations

  • Issue and customer impact: UTF-8 enabled collations cannot be used with the following features:

    Warning

    Creating a bacpac of a database containing table columns defined as CHAR or VARCHAR that use more than 4000 bytes will fail.

    Note

    There is currently no UI support to choose UTF-8 enabled collations in Azure Data Studio or SQL Server Data Tools (SSDT). The latest SQL Server Management Studio (SSMS) version 18 supports choice of UTF-8 enabled collations in the UI.

  • Applies to: SQL Server 2019 (15.x) RTM

  • Issue and customer impact: The notification email from Master Data Services (MDS) contains a broken link. The link navigates to a page that returns an error like the following message:

    The view 'Index' or its master was not found or no view engine supports the searched locations.

  • Workaround: Open the MDS portal and go to the resource manually.

  • Applies to: SQL Server 2019 (15.x) RTM

See also

Machine Learning Services

For issues in SQL Server Machine Learning Services, see Known issues in SQL Server Machine Learning Services.

info_tip Get help