SQL Server 2019 (15.x) 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:
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:
- SQL Server Management Studio (SSMS) version 18.0, 18.1, 18.2, or 18.3 is installed on the server.
- SQL Server 2019 (15.x) installation is attempted from removable media. For example, the installation media is a DVD.
Workaround:
- Uninstall any version of SSMS older than SSMS 18.3.1.
- Install a newer version of SSMS (18.3.1 or later). For the latest version, see Download SSMS.
- 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
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