New parameter productcoveredbysa : Command proposal

[sara921-spec]

Command proposal

A new installation parameter, /PRODUCTCOVEREDBYSA, was introduced in SQL Server 2022 (16.x). This parameter indicates whether the provided product key (/PID=) license is covered under a Software Assurance or SQL Server Subscription contract, or just a SQL Server license.

Proposed parameters

Parameter	Mandatory	Data type	Description	Default value	Allowed values
productcoveredbysa	yes	String	Detailed description	None	true,False

"PRODUCTCOVEREDBYSA"

Special considerations or limitations

We have the new parameter "PRODUCTCOVEREDBYSA" available for "Install-SqlDscResource" but currently there is no resource using that command and this is to add the parameter to the DSC resource "DSC_SqlSetup" for the SQL 2022 installs.

SqlServerDsc-16.6.0\source\DSCResources\DSC_SqlSetup

#1798

[sara921-spec]

Documentation : https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver16

[johlju]

Suggest we add a boolean parameter ProductCoveredBySA to the existing logic in the resource SqlSetup. I think this should be fairly easy to add for someone in the community.

Note

Suggest not use the new command Install-SqlDscServer as that would be a much larger undertaking, one that work was started for in PR #1912 but was not completed.