SqlRs: Integration test fails on SQL Server 2022

[johlju]

Problem description

The integration tests for SqlRS has started to fail when integration tests run the tests for SQL Server 2022. Something has changed but unclear what.

Verbose logs

##[error]    [-] Should compile and apply the MOF without throwing 38.72s (38.71s|11ms)
##[error]     Expected no exception to be thrown, but an exception "PowerShell DSC resource DSC_SqlRS  failed to execute Set-TargetResource functionality with error message: The parameter is incorrect.  " was thrown from D:\a\1\s\tests\Integration\DSC_SqlRS_Default.Integration.Tests.ps1:151 char:17
##[error]         + ...               Start-DscConfiguration @startDscConfigurationParameters
##[error]         +                   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~.
##[error]     at } | Should -Not -Throw, D:\a\1\s\tests\Integration\DSC_SqlRS_Default.Integration.Tests.ps1:152

DSC configuration

# See integration test: https://github.com/dsccommunity/SqlServerDsc/blob/026647ca36ce154a86facf195d00c27c2668281a/tests/Integration/DSC_SqlRS_Default.config.ps1#L169C1-L194C2

Configuration DSC_SqlRS_ConfigureReportingServices_Config
{
    Import-DscResource -ModuleName 'SqlServerDsc'

    node $AllNodes.NodeName
    {
        SqlRS 'Integration_Test'
        {
            # Instance name for the Reporting Services.
            InstanceName         = $Node.InstanceName

            <#
                Instance for Reporting Services databases.
                Note: This instance is created in a prior integration test.
            #>
            DatabaseServerName   = $Node.DatabaseServerName
            DatabaseInstanceName = $Node.DatabaseInstanceName
            Encrypt              = 'Optional'

            PsDscRunAsCredential = New-Object `
                -TypeName System.Management.Automation.PSCredential `
                -ArgumentList @(
                    $Node.RunAs_UserName, (ConvertTo-SecureString -String $Node.RunAs_Password -AsPlainText -Force))
        }
    }
}

Suggested solution

Unknown. Something has changed with SQL Server 2022 and work has to be done to pin point exact cause.

SQL Server edition and version

# Integration tests for SQL Server 2022 installs this version: https://github.com/dsccommunity/SqlServerDsc/blob/026647ca36ce154a86facf195d00c27c2668281a/tests/Integration/DSC_SqlRSSetup.Integration.Tests.ps1#L79-L80

SQL Server PowerShell modules

SqlServer that the integration tests installs.

Operating system

Fails on both Windows Server 2019 and Windows Server 2022.

PowerShell version

5.1

SqlServerDsc version

Code from main branch

[johlju]

There seems to be an issue with the SqlRS resource not working on the SQL Server 2022 instances that are installed as part of the integration tests. This will prevent us from merging PR's to the main branch because it fail to release a new preview release.

I won't have time looking into what causing the error.

[johlju]

Worst case we have to disable the tests.

[johlju]

The PR #2008 has temporarily disabled the tests that fails. They should be re-enabled when this issue is resolved.

SqlServerDsc/tests/Integration/DSC_SqlRS.Integration.Tests.ps1

Lines 81 to 82 in 3ef838b

	# TODO: SQL Server 2022 has been disabled due to unknown issue with the resource SqlRS. See issue #2009.
	Describe "$($script:dscResourceName)_Integration" -Tag @('Integration_SQL2016', 'Integration_SQL2017', 'Integration_SQL2019'<#, 'Integration_SQL2022'#>) {

SqlServerDsc/tests/Integration/DSC_SqlRS_Default.Integration.Tests.ps1

Lines 81 to 82 in 3ef838b

	# TODO: SQL Server 2022 has been disabled due to unknown issue with the resource SqlRS. See issue #2009.
	Describe "$($script:dscResourceName)_Integration" -Tag @('Integration_SQL2016', 'Integration_SQL2017', 'Integration_SQL2019'<#, 'Integration_SQL2022'#>) {