BREAKING CHANGE: SqlRS: No need to run the method InitializeReportServer for any versions of SSRS

[johlju]

Problem description

According to #1698 (comment) running the method InitializeReportServer might not be necessary.

SqlServerDsc/source/DSCResources/DSC_SqlRS/DSC_SqlRS.psm1

Lines 495 to 503 in 82db5c7

	$invokeRsCimMethodParameters = @{
	CimInstance = $reportingServicesData.Configuration
	MethodName = 'InitializeReportServer'
	Arguments = @{
	InstallationId = $reportingServicesData.Configuration.InstallationID
	}
	}
	Invoke-RsCimMethod @invokeRsCimMethodParameters

Though according to the documentation ConfigurationSetting Method - InitializeReportServer the method InitializeReportServer do serve some purpose, but unclear when it must be run.

Verbose logs

Not available

DSC configuration

See integration tests for SqlRS in this repo.

Suggested solution

The following code should be run for all versions on SQL Server Reporting Services.

SqlServerDsc/source/DSCResources/DSC_SqlRS/DSC_SqlRS.psm1

Lines 466 to 482 in 82db5c7

	<#
	When initializing SSRS 2019, the call to InitializeReportServer
	always fails, even if IsInitialized flag is $false.
	It also seems that simply restarting SSRS at this point initializes
	it.
	We will ignore $SuppressRestart here.
	#>
	if ($reportingServicesData.SqlVersion -ge 15)
	{
	Write-Verbose -Message $script:localizedData.RestartToFinishInitialization
	Restart-ReportingServicesService -InstanceName $InstanceName -WaitTime 30
	$restartReportingService = $false
	}

SQL Server edition and version

Any

SQL Server PowerShell modules

Not applicable

Operating system

Any

PowerShell version

Not applicable

SqlServerDsc version

Version in main branch.