Skip to content

Latest commit

 

History

History
143 lines (85 loc) · 8.05 KB

File metadata and controls

143 lines (85 loc) · 8.05 KB
title SQL Server 2019 Release Notes | Microsoft Docs
ms.date 08/21/2019
ms.prod sql
ms.reviewer
ms.technology release-landing
ms.topic article
ms.assetid 13942af8-5a40-4cef-80f5-918386767a47
author MikeRayMSFT
ms.author mikeray
monikerRange = sql-server-ver15 || = sqlallproducts-allversions

SQL Server 2019 preview release notes

[!INCLUDEtsql-appliesto-ssver15-xxxx-xxxx-xxx]

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

What's New in SQL Server 2019

Note

The content is published for the [!INCLUDEsql-server-2019] release candidate. The release candidate is pre-release software. The information is subject to change. For information about support scenarios, refer to Support.

[!INCLUDEsql-server-2019] release candidate (RC)

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

[!INCLUDESQL Server 2019] RC is available only as Evaluation Edition. No other editions are available.

Complete details about support and licensing for release candidate software are in license_Eval.rtf with your installation media.

[!INCLUDEctp-support-exclusion]

Documentation

  • Issue and customer impact: Documentation for SQL Server 2019 (15.x) is limited and content is included with the [!INCLUDEssSQL17] documentation set. Content in articles that is specific to SQL Server 2019 (15.x) is noted with Applies to.

  • 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.

  • Issue and customer impact: No offline content is available for SQL Server 2019 (15.x).

Build number

The build number for SQL Server 2019 RC on Windows, Linux, and containers is 15.0.1900.25. The build number for SQL Server 2019 RC used in big data clusters is 15.0.1900.47.

Hardware and software requirements

Features excluded from support

  • Issue and customer impact: [!INCLUDESQL Server 2019] excludes support for the following components, features, and scenarios:

    • SQL Server Analysis Services
    • SQL Server Reporting Services
    • Always On availability groups on Kubernetes
  • Workaround: None. Exclusion applies to all customers, including participants in SQL Early Adopter Program.

  • Applies to: Release candidate

Updated compiler

  • Issue and customer impact: [!INCLUDESQL Server 2019] is built with an updated compiler. CTP 2.1 had a known issue where results for floating point and other conversion scenarios may have returned a different value than previous versions because of the updated compiler. CTP 2.2 includes work to ensure that the affected scenarios return the same results as previous versions of [!INCLUDEssNoVersion]. As of the release candidate release we do not know any remaining issues. Please report any result anomalies compared to [!INCLUDEss2017] to [[!INCLUDEssNoVersion] team](https://aka.ms/sqlfeedback) immediately.

  • Workaround: N/A

  • Applies to: Release candidate

Installation Wizard may wait between EULA pages

  • Issue and customer impact: During installation with Installation Wizard, the process may wait an extended amount of time between the end user license agreement (EULA) for R Services and the EULA for Python.

  • Workaround: Wait for the Installation Wizard to proceed. The time to wait may exceed 30 minutes.

  • Applies to: [!INCLUDESQL Server 2019] CTP 3.0

UTF-8 collations

  • Issue and customer impact: UTF-8 enabled collations cannot be used with some other [!INCLUDEssNoVersion] features. UTF-8 is not supported when the following [!INCLUDEssNoVersion] features are in use:

    [!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.

  • Workaround: No workaround for [!INCLUDESQL Server 2019] CTPs.

  • Applies to: All CTP releases.

Always Encrypted with secure enclaves

  • Issue and customer impact: Rich computations are pending performance optimizations and error-handling enhancements, and are currently disabled by default.

  • Workaround: To enable rich computations, run DBCC traceon(127,-1). For details, see Enable rich computations.

  • Applies to: [!INCLUDESQL Server 2019] CTP 3.2, CTP 3.1

SQL Server Configuration Manager may not start

  • Issue and customer impact: SQL Server Configuration Manager (SSCM) does not start on a machine without VCRuntime 140. When starting SSCM, the user may see the following dialog:

    MMC could not create the snap-in. The snap-in might not have been installed correctly.

  • Workaround: Install the latest VC Runtime 2013 (x86):

  • Applies to: [!INCLUDESQL Server 2019] CTP 3.1, CTP 3.0, CTP 2.5.

Always On Availability Group Kubernetes operator not supported

  • Issue and customer impact: The Kubernetes operator for Always On Availability Groups is not supported in this release candidate and will not be available at RTM.

  • Workaround: None

  • Applies to: [!INCLUDESQL Server 2019] Release candidate

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 release candidate.

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

MS_Logo_X-Small