MS SQL 2019 Support Timeline

Products

• Clarity PPM On Premise

Issue/Introduction

Microsoft (MS) is ending its mainstream support for SQL2016 this July and we would like to move to SQL2019, however that version is not supported by Clarity. Is there a timeline for offering SQL2019 support, either natively or in compatibility mode, that you could share so we can plan accordingly?

Environment

• CLARITY INTEGRATIONS & INSTALLATIONS
• Microsoft SQL Server

Resolution

Support for MSSQL Server 2019 is available in 15.9.2. See: Specifications: Summary of Changes in Clarity 15.9.2

CLARITY 15.8.1

• Microsoft SQL Server 2017 Enterprise Edition
• Microsoft SQL Server 2016 Enterprise Edition: Service Pack 2 or higher (higher is associated with service pack)

CLARITY 15.9.1

• Microsoft SQL Server 2017
• Microsoft SQL Server 2017 Enterprise (CU-21) (Full Mode)
• Microsoft SQL Server 2016 Enterprise Edition: Service Pack 2 or higher (higher is associated with service pack)

CLARITY 15.9.2

• Microsoft SQL Server 2019 Enterprise CU9
• Microsoft SQL Server 2017
• Microsoft SQL Server 2017 Enterprise (CU-21) (Full Mode)
• Microsoft SQL Server 2016 Enterprise Edition: Service Pack 2 or higher (higher is associated with service pack)

Additional Information

Jasper Reports Server v7.8 General Availability Announcement here.

• As part of the Jaspersoft 7.8 testing we also certified JS with SQL Server 2017 and 2019.

Specifications: Jaspersoft Database Components

• Microsoft SQL Server 2019 (Jaspersoft 7.8 only)
• Microsoft SQL Server 2017 (Jaspersoft 7.8 only)
• Microsoft SQL Server 2016 Enterprise Edition: Service Pack 2 or higher (Jaspersoft 7.1 and 7.8)
• Microsoft SQL Server 2014 Enterprise Edition: Service Pack 2 or higher (Jaspersoft 7.1 and 7.8)