Install-SqlDscServer: Fails to install when missing ASSysAdminAccounts

[johlju]

Problem description

When installing the feature AS and not providing the non-mandatory parameter ASSysAdminAccounts results in failure.

Verbose logs

Microsoft (R) SQL Server 2022 16.00.1000.06
Copyright (c) 2022 Microsoft.  All rights reserved.

The following error occurred:
You must provision the system with at least one system administrator.

Error result: -2068578304
Result facility code: 1204
Result error code: 0

Please review the summary.txt log for further details
Invoke-SetupAction : Setup exited with code '-2068578304'. Please see the 'Summary.txt' log file in the 'Setup Bootstra
p\Log' folder.
At C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\16.1.0\SqlServerDsc.psm1:7399 char:5
+     Invoke-SetupAction @PSBoundParameters -ErrorAction 'Stop'
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (SQL2022:String) [Invoke-SetupAction], Exception
    + FullyQualifiedErrorId : ISA0001,Invoke-SetupAction

How to reproduce

Run the following command, not providing the parameter ASSysAdminAccounts.

Install-SqlDscServer -Install -AcceptLicensingTerms -MediaPath e:\ -InstanceName 'SQL2022' -Features 'AS' -SqlSysAdminAccounts '[email protected]' -SuppressPrivacyStatementNotice  -Verbose

Expected behavior

Throw an exception saying mandatory parameter ASSysAdminAccounts is missing.

Current behavior

Starting the installation resulting in failure.

Suggested solution

Add logic to handle that when feature AS is installed that the parameter ASSysAdminAccounts must also be specified.

Operating system the target node is running

OsName               : Microsoft Windows Server 2022 Standard
OsOperatingSystemSKU : StandardServerEdition
OsArchitecture       : 64-bit
WindowsVersion       : 2009
WindowsBuildLabEx    : 20348.1.amd64fre.fe_release.210507-1500
OsLanguage           : en-US
OsMuiLanguages       : {en-US}

PowerShell version and build the target node is running

Name                           Value
----                           -----
PSVersion                      5.1.20348.859
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.20348.859
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

Module version used

Name         Version Path
----         ------- ----
SqlServerDsc 16.1.0  C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\16.1.0\SqlServerDsc.psd1