Bug 2153427

Summary:	Support SQL Server version 2022
Product:	Red Hat Enterprise Linux 8	Reporter:	Sergei Petrosian <spetrosi>
Component:	ansible-collection-microsoft-sql	Assignee:	Sergei Petrosian <spetrosi>
Status:	CLOSED ERRATA	QA Contact:	Daniel Yeisley <dyeisley>
Severity:	unspecified	Docs Contact:	Alexandra Nikandrova <anikandr>
Priority:	unspecified
Version:	8.8	CC:	anikandr
Target Milestone:	rc	Keywords:	Triaged
Target Release:	---	Flags:	pm-rhel: mirror+
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	ansible-collection-microsoft-sql-1.3.0-1.el8	Doc Type:	Enhancement
Doc Text:	.Microsoft SQL Server Ansible role supports configuring SQL Server version 2022 Previously, Microsoft SQL Ansible role supported only configuring SQL Server version 2017 and version 2019. This update provides you with the support for SQL Server version 2022 for Microsoft SQL Ansible role. Now, you can set `mssql_version` value to `2022` for configuring a new SQL Server 2022 or upgrading SQL Server from version 2019 to version 2022. Note that upgrade of an SQL Server from version 2017 to version 2022 is unavailable.	Story Points:	---
Clone Of:
Clones:	2153428 (view as bug list)		Environment:
Last Closed:	2023-05-16 08:41:54 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Sergei Petrosian 2022-12-14 14:46:08 UTC

Description:
SQL Server added version 2022, the role should support installing this version and upgrading to this version from previous versions 2017 and 2019.

Version-Release number of selected component (if applicable):
8.8

Steps to Reproduce:
1. Use the role to configure SQL Server 2017 or 2019 by setting the mssql_version variable.
2. Set mssql_version: 2022 and mssql_upgrade: true and run the role again to upgrade.

Additional info:
Is being fixed upstream in https://github.com/linux-system-roles/mssql/pull/148

Comment 21 errata-xmlrpc 2023-05-16 08:41:54 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (ansible-collection-microsoft-sql bug fix and enhancement update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2023:2895