search

dsccommunity / SqlServerDsc

This module contains DSC resources for deployment and configuration of Microsoft SQL Server.
MIT License
360 stars 225 forks source link

New parameter productcoveredbysa : Command proposal #2040

Closed sara921-spec closed 1 month ago

sara921-spec commented 3 months ago

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.

image

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

https://github.com/dsccommunity/SqlServerDsc/issues/1798

sara921-spec commented 3 months ago

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

johlju commented 3 months ago

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.