[Bug]: Error configuring SSRS with SQL Server 2022

[DanGough]

Description

Adding a SQL Server 2022 VM produces an error when it gets to the SSRS section:

10:23:23|00:09:40|00:00:00.000| - Executing lab command activity: 'Configuring SSRS' on machines 'TESTDB'
VERBOSE: [10:23:23][Write-ScreenInfo] Waiting for completion
VERBOSE: [10:23:23][Write-ScreenInfo] 10:23:23|00:09:40|00:00:00.000|   - Waiting for completion
10:23:23|00:09:40|00:00:00.000|   - Waiting for completion
VERBOSE: [10:23:23][Invoke-LabCommand] Executing lab command activity 'Configuring SSRS' on machines 'TESTDB'
VERBOSE: [10:23:23][Write-LogFunctionEntry] Get-LabVM Entering... (IncludeLinux=True)
VERBOSE: [10:23:23][Write-LogFunctionEntry] Get-LabVM Entering... (ComputerName=TESTDB,IncludeLinux=True)
VERBOSE: [10:23:23][Write-LogFunctionEntry] Get-LabVMStatus Entering... (ComputerName=TESTDB,AsHashTable=True)
VERBOSE: [10:23:23][Write-LogFunctionEntry] Get-LabVM Entering... (ComputerName=TESTDB,IncludeLinux=True)
VERBOSE: [10:23:23][Write-LogFunctionExit] Get-LabVMStatus...leaving...(Time elapsed: 00:00:00:015)
VERBOSE: [10:23:23][Invoke-LabCommand] Creating session to computer(s) 'TESTDB'
VERBOSE: [10:23:23][Write-LogFunctionEntry] New-LabPSSession Entering... (ComputerName=TESTDB,DoNotUseCredSsp=<null>,UseLocalCredential=<null>,Credential=<null>,IgnoreAzureLabSources=<null>)
VERBOSE: [10:23:23][Write-LogFunctionEntry] Get-LabVM Entering... (ComputerName=TESTDB,IncludeLinux=True)
VERBOSE: [10:23:23][New-LabPSSession] Connecting to machine 'TESTDB' using the IP address '192.168.11.3'
VERBOSE: [10:23:23][New-LabPSSession] Creating a new PSSession to machine '192.168.11.3:5985' (UserName='TESTDB\install', Password='Somepass1', DoNotUseCredSsp='False')
VERBOSE: [10:23:23][Write-LogFunctionEntry] Get-LabVM Entering... (ComputerName=TESTDB)
VERBOSE: [10:23:23][New-LabPSSession] Session TESTDB_be36f941-1fc5-43c8-a47e-9abba1ee3688 is available and will be reused
VERBOSE: [10:23:23][Write-LogFunctionExit] New-LabPSSession...leaving - return value is 'Session IDs: 91'...(Time elapsed: 00:00:00:000)
VERBOSE: [10:23:23][Write-LogFunctionEntry] Invoke-LWCommand Entering... (AsJob=<null>,Verbose=True,ComputerName=TESTDB,Retries=3,PassThru=<null>,ScriptBlock=function Get-ConfigSet
{
    $class = Get-WmiObject -List -Namespace root\microsoft -Class MSReportServer_ConfigurationSetting -Recurse
    Get-CimInstance -Namespace $class.__NAMESPACE -Class $class.Name

    if ($class.__NAMESPACE -match '\\v(?<version>\d\d)\\*.')
    {
        $version = $Matches.version
        Write-Verbose "Installed SSRS version is $version"
    }
}

function Get-Instance
{
    $class = Get-WmiObject -List -Namespace root\microsoft -Class MSReportServer_Instance -Recurse
    $instance = Get-CimInstance -Namespace $class.__NAMESPACE -Class $class.Name
}

$configSet = Get-ConfigSet

try
{
    [Microsoft.SqlServer.Management.Common.ServerConnection]
}
catch
{
    if (Get-Module -List SqlServer)
    {
        Import-Module SqlServer
    }
    else
    {
        Import-Module SqlPs
    }
}

if (-not $configSet.IsInitialized)
{
    # Get the ReportServer and ReportServerTempDB creation script
    $dbScript = ($configSet | Invoke-CimMethod -MethodName GenerateDatabaseCreationScript -Arguments @{DatabaseName = 'ReportServer'
VERBOSE: [10:23:23][Invoke-LWCommand] Starting Activity 'Configuring SSRS'
Exception calling "Connect" with "0" argument(s): "Failed to connect to server TESTDB."
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : ConnectionFailureException
    + PSComputerName        : 192.168.11.3
 
You cannot call a method on a null-valued expression.
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull
    + PSComputerName        : 192.168.11.3
 
You cannot call a method on a null-valued expression.
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull
    + PSComputerName        : 192.168.11.3
 
VERBOSE: [10:24:34][Invoke-LWCommand] The Output of the task on machine 'TESTDB' will be available in the variable 'AL_e398836f-4f6e-4ee2-817c-9430031850ac'
VERBOSE: [10:24:34][Invoke-LWCommand] Finished Installation Activity 'Configuring SSRS'

Steps to reproduce the issue

New-LabDefinition -Name 'TEST' -DefaultVirtualizationEngine 'HyperV'

$SqlServerIsoPath = (Get-ChildItem -File -Filter *SQL*2022* -Path "$(Get-LabSourcesLocation -Local)\ISOs").Fullname
Add-LabIsoImageDefinition -Path $SqlServerIsoPath -Name SQLServer2022

Set-LabInstallationCredential -Username install -Password Somepass1

$dbRole = Get-LabMachineRoleDefinition -Role SQLServer2022
Add-LabMachineDefinition -Name TESTDB -Roles $dbRole -Memory 8GB -Processors 4 -OperatingSystem 'Windows Server 2022 Datacenter (Desktop Experience)'

Install-Lab -Verbose

PowerShell Version

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

AutomatedLab Version

Name                      Version
----                      -------
AutomatedLab              5.51.4 
AutomatedLab.Common       2.3.30 
AutomatedLab.Recipe       5.51.4 
AutomatedLab.Ships        5.51.4 
AutomatedLabCore          5.51.4 
AutomatedLabDefinition    5.51.4 
AutomatedLabNotifications 5.51.4 
AutomatedLabTest          5.51.4 
AutomatedLabUnattended    5.51.4 
AutomatedLabWorker        5.51.4