Skip to content

Latest commit

 

History

History
86 lines (53 loc) · 4.49 KB

sql-server-2019-release-notes.md

File metadata and controls

86 lines (53 loc) · 4.49 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic monikerRange
SQL Server 2019 release notes
Find information about SQL Server 2019 (15.x) limitations, known issues, help resources, and other release notes.
MikeRayMSFT
mikeray
11/04/2019
sql
release-landing
release-notes
>= sql-server-2016

SQL Server 2019 release notes

[!INCLUDESQL Server 2019]

This article describes limitations and known issues for the [!INCLUDESQL Server 2019]. For related information, see:

[What's New in [!INCLUDESQL Server 2019]](../sql-server/what-s-new-in-sql-server-ver15.md)

[!INCLUDEsql-server-2019]

[!INCLUDESQL Server 2019] is the latest public release of [!INCLUDESQL Server 2019].

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

Documentation

  • Issue and customer impact: [!INCLUDEssNoVersion] 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.

[!INCLUDE sql-server-servicing-updates-version-15]

Known Issues

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

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

  • Issue and customer impact: [!INCLUDESQL Server 2019] 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. [!INCLUDESQL Server 2019] 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 [!INCLUDESQL Server 2019] normally.

  • Applies to: [!INCLUDESQL Server 2019]

UTF-8 collations can't be used with certain features

  • 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 [!INCLUDEssManStudioFull] (SSMS) version 18 supports choice of UTF-8 enabled collations in the UI.

  • Applies to: [!INCLUDESQL Server 2019] RTM

Master Data Service notification email contains broken link

  • 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: [!INCLUDESQL Server 2019] RTM

See also

Machine Learning Services

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

[!INCLUDEget-help-options-msft-only]