SQL Server 2019 release notes

Applies to: SQL Server 2019 (15.x)

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/4518398.

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: 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 can't be used with certain features

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

  • In-Memory OLTP tables
  • Always Encrypted with Secure Enclaves (When not using Secure Enclaves, Always Encrypted can use UTF-8)

  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

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: SQL Server 2019 (15.x) RTM

See also

• Hardware and Software Requirements for Installing SQL Server

Machine Learning Services

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

Get help

• Ideas for SQL: Have suggestions for improving SQL Server?
• Microsoft Q & A (SQL Server)
• DBA Stack Exchange (tag sql-server): Ask SQL Server questions
• Stack Overflow (tag sql-server): Answers to SQL development questions
• Reddit: General discussion about SQL Server
• Microsoft SQL Server License Terms and Information
• Support options for business users
• Contact Microsoft
• Additional SQL Server help and feedback

Contribute to SQL documentation

Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page.

For more information, see How to contribute to SQL Server documentation