dsc/ext/PsGallery/SqlServerDsc.11.2.0.0/DSCResources/MSFT_SqlRS/MSFT_SqlRS.psm1
|
Import-Module -Name (Join-Path -Path (Split-Path (Split-Path $PSScriptRoot -Parent) -Parent) ` -ChildPath 'SqlServerDscHelper.psm1') ` -Force <# .SYNOPSIS Gets the SQL Reporting Services initialization status. .PARAMETER InstanceName Name of the SQL Server Reporting Services instance to be configured. .PARAMETER DatabaseServerName Name of the SQL Server to host the Reporting Service database. .PARAMETER DatabaseInstanceName Name of the SQL Server instance to host the Reporting Service database. #> function Get-TargetResource { [CmdletBinding()] [OutputType([System.Collections.Hashtable])] param ( [Parameter(Mandatory = $true)] [System.String] $InstanceName, [Parameter(Mandatory = $true)] [System.String] $DatabaseServerName, [Parameter(Mandatory = $true)] [System.String] $DatabaseInstanceName ) $reportingServicesData = Get-ReportingServicesData -InstanceName $InstanceName if ( $null -ne $reportingServicesData.Configuration ) { if ( $reportingServicesData.Configuration.DatabaseServerName.Contains('\') ) { $DatabaseServerName = $reportingServicesData.Configuration.DatabaseServerName.Split('\')[0] $DatabaseInstanceName = $reportingServicesData.Configuration.DatabaseServerName.Split('\')[1] } else { $DatabaseServerName = $reportingServicesData.Configuration.DatabaseServerName $DatabaseInstanceName = 'MSSQLSERVER' } $isInitialized = $reportingServicesData.Configuration.IsInitialized if ( $isInitialized ) { if ( $reportingServicesData.Configuration.SecureConnectionLevel ) { $isUsingSsl = $true } else { $isUsingSsl = $false } $reportServerVirtualDirectory = $reportingServicesData.Configuration.VirtualDirectoryReportServer $reportsVirtualDirectory = $reportingServicesData.Configuration.VirtualDirectoryReportManager $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'ListReservedUrls' } $reservedUrls = Invoke-RsCimMethod @invokeRsCimMethodParameters $reportServerReservedUrl = @() $reportsReservedUrl = @() for ( $i = 0; $i -lt $reservedUrls.Application.Count; ++$i ) { if ( $reservedUrls.Application[$i] -eq 'ReportServerWebService' ) { $reportServerReservedUrl += $reservedUrls.UrlString[$i] } if ( $reservedUrls.Application[$i] -eq $reportingServicesData.ReportsApplicationName ) { $reportsReservedUrl += $reservedUrls.UrlString[$i] } } } else { <# Make sure the value returned is false, if the value returned was either empty, $null or $false. Fic for issue #822. #> [System.Boolean] $isInitialized = $false } } else { throw New-TerminatingError -ErrorType SSRSNotFound -FormatArgs @($InstanceName) -ErrorCategory ObjectNotFound } return @{ InstanceName = $InstanceName DatabaseServerName = $DatabaseServerName DatabaseInstanceName = $DatabaseInstanceName ReportServerVirtualDirectory = $reportServerVirtualDirectory ReportsVirtualDirectory = $reportsVirtualDirectory ReportServerReservedUrl = $reportServerReservedUrl ReportsReservedUrl = $reportsReservedUrl UseSsl = $isUsingSsl IsInitialized = $isInitialized } } <# .SYNOPSIS Initializes SQL Reporting Services. .PARAMETER InstanceName Name of the SQL Server Reporting Services instance to be configured. .PARAMETER DatabaseServerName Name of the SQL Server to host the Reporting Service database. .PARAMETER DatabaseInstanceName Name of the SQL Server instance to host the Reporting Service database. .PARAMETER ReportServerVirtualDirectory Report Server Web Service virtual directory. Optional. .PARAMETER ReportsVirtualDirectory Report Manager/Report Web App virtual directory name. Optional. .PARAMETER ReportServerReservedUrl Report Server URL reservations. Optional. If not specified, 'http://+:80' URL reservation will be used. .PARAMETER ReportsReservedUrl Report Manager/Report Web App URL reservations. Optional. If not specified, 'http://+:80' URL reservation will be used. .PARAMETER UseSsl If connections to the Reporting Services must use SSL. If this parameter is not assigned a value, the default is that Reporting Services does not use SSL. .NOTES To find out the parameter names for the methods in the class MSReportServer_ConfigurationSetting it's easy to list them using the following code. Example for listing ``` $methodName = 'ReserveUrl' $instanceName = 'SQL2016' $sqlMajorVersion = '13' $getCimClassParameters = @{ ClassName = 'MSReportServer_ConfigurationSetting' Namespace = "root\Microsoft\SQLServer\ReportServer\RS_$instanceName\v$sqlMajorVersion\Admin" } (Get-CimClass @getCimClassParameters).CimClassMethods[$methodName].Parameters ``` Or run the following using the helper function in this code. Make sure to have the helper function loaded in the session. ``` $methodName = 'ReserveUrl' $instanceName = 'SQL2016' $reportingServicesData = Get-ReportingServicesData -InstanceName $InstanceName $reportingServicesData.Configuration.CimClass.CimClassMethods[$methodName].Parameters ``` SecureConnectionLevel (the parameter UseSsl): The SecureConnectionLevel value can be 0,1,2 or 3, but since SQL Server 2008 R2 this was changed. So we are just setting it to 0 (off) and 1 (on). "In SQL Server 2008 R2, SecureConnectionLevel is made an on/off switch, default value is 0. For any value greater than or equal to 1 passed through SetSecureConnectionLevel method API, SSL is considered on..." https://docs.microsoft.com/en-us/sql/reporting-services/wmi-provider-library-reference/configurationsetting-method-setsecureconnectionlevel #> function Set-TargetResource { [CmdletBinding()] param ( [Parameter(Mandatory = $true)] [System.String] $InstanceName, [Parameter(Mandatory = $true)] [System.String] $DatabaseServerName, [Parameter(Mandatory = $true)] [System.String] $DatabaseInstanceName, [Parameter()] [System.String] $ReportServerVirtualDirectory, [Parameter()] [System.String] $ReportsVirtualDirectory, [Parameter()] [System.String[]] $ReportServerReservedUrl, [Parameter()] [System.String[]] $ReportsReservedUrl, [Parameter()] [System.Boolean] $UseSsl ) $reportingServicesData = Get-ReportingServicesData -InstanceName $InstanceName if ( $null -ne $reportingServicesData.Configuration ) { if ( $InstanceName -eq 'MSSQLSERVER' ) { if ( [System.String]::IsNullOrEmpty($ReportServerVirtualDirectory) ) { $ReportServerVirtualDirectory = 'ReportServer' } if ( [System.String]::IsNullOrEmpty($ReportsVirtualDirectory) ) { $ReportsVirtualDirectory = 'Reports' } $reportingServicesServiceName = 'ReportServer' $reportingServicesDatabaseName = 'ReportServer' } else { if ( [System.String]::IsNullOrEmpty($ReportServerVirtualDirectory) ) { $ReportServerVirtualDirectory = "ReportServer_$InstanceName" } if ( [System.String]::IsNullOrEmpty($ReportsVirtualDirectory) ) { $ReportsVirtualDirectory = "Reports_$InstanceName" } $reportingServicesServiceName = "ReportServer`$$InstanceName" $reportingServicesDatabaseName = "ReportServer`$$InstanceName" } if ( $DatabaseInstanceName -eq 'MSSQLSERVER' ) { $reportingServicesConnection = $DatabaseServerName } else { $reportingServicesConnection = "$DatabaseServerName\$DatabaseInstanceName" } $wmiOperatingSystem = Get-CimInstance -ClassName Win32_OperatingSystem -Namespace 'root/cimv2' -ErrorAction SilentlyContinue if ( $null -eq $wmiOperatingSystem ) { throw 'Unable to find WMI object Win32_OperatingSystem.' } $language = $wmiOperatingSystem.OSLanguage if ( -not $reportingServicesData.Configuration.IsInitialized ) { New-VerboseMessage -Message "Initializing Reporting Services on $DatabaseServerName\$DatabaseInstanceName." # If no Report Server reserved URLs have been specified, use the default one. if ( $null -eq $ReportServerReservedUrl ) { $ReportServerReservedUrl = @('http://+:80') } # If no Report Manager/Report Web App reserved URLs have been specified, use the default one. if ( $null -eq $ReportsReservedUrl ) { $ReportsReservedUrl = @('http://+:80') } if ( $reportingServicesData.Configuration.VirtualDirectoryReportServer -ne $ReportServerVirtualDirectory ) { New-VerboseMessage -Message "Setting report server virtual directory on $DatabaseServerName\$DatabaseInstanceName to $ReportServerVirtualDirectory." $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'SetVirtualDirectory' Arguments = @{ Application = 'ReportServerWebService' VirtualDirectory = $ReportServerVirtualDirectory Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters $ReportServerReservedUrl | ForEach-Object -Process { New-VerboseMessage -Message "Adding report server URL reservation on $DatabaseServerName\$DatabaseInstanceName`: $_." $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'ReserveUrl' Arguments = @{ Application = 'ReportServerWebService' UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } } if ( $reportingServicesData.Configuration.VirtualDirectoryReportManager -ne $ReportsVirtualDirectory ) { New-VerboseMessage -Message "Setting reports virtual directory on $DatabaseServerName\$DatabaseInstanceName to $ReportServerVirtualDirectory." $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'SetVirtualDirectory' Arguments = @{ Application = $reportingServicesData.ReportsApplicationName VirtualDirectory = $ReportsVirtualDirectory Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters $ReportsReservedUrl | ForEach-Object -Process { New-VerboseMessage -Message "Adding reports URL reservation on $DatabaseServerName\$DatabaseInstanceName`: $_." $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'ReserveUrl' Arguments = @{ Application = $reportingServicesData.ReportsApplicationName UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } } $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'GenerateDatabaseCreationScript' Arguments = @{ DatabaseName = $reportingServicesDatabaseName IsSharePointMode = $false Lcid = $language } } $reportingServicesDatabaseScript = Invoke-RsCimMethod @invokeRsCimMethodParameters # Determine RS service account $reportingServicesServiceAccountUserName = (Get-CimInstance -ClassName Win32_Service | Where-Object -FilterScript { $_.Name -eq $reportingServicesServiceName }).StartName $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'GenerateDatabaseRightsScript' Arguments = @{ DatabaseName = $reportingServicesDatabaseName UserName = $reportingServicesServiceAccountUserName IsRemote = $false IsWindowsUser = $true } } $reportingServicesDatabaseRightsScript = Invoke-RsCimMethod @invokeRsCimMethodParameters <# Import-SQLPSModule cmdlet will import SQLPS (SQL 2012/14) or SqlServer module (SQL 2016), and if importing SQLPS, change directory back to the original one, since SQLPS changes the current directory to SQLSERVER:\ on import. #> Import-SQLPSModule Invoke-Sqlcmd -ServerInstance $reportingServicesConnection -Query $reportingServicesDatabaseScript.Script Invoke-Sqlcmd -ServerInstance $reportingServicesConnection -Query $reportingServicesDatabaseRightsScript.Script $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'SetDatabaseConnection' Arguments = @{ Server = $reportingServicesConnection DatabaseName = $reportingServicesDatabaseName Username = '' Password = '' <# Can be set to either: 0 = Windows 1 = Sql Server 2 = Windows Service (Integrated Security) When set to 2 the Reporting Server Web service will use either the ASP.NET account or an application pool’s account and the Windows service account to access the report server database. See more in the article https://docs.microsoft.com/en-us/sql/reporting-services/wmi-provider-library-reference/configurationsetting-method-setdatabaseconnection#remarks #> CredentialsType = 2 } } Invoke-RsCimMethod @invokeRsCimMethodParameters $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'InitializeReportServer' Arguments = @{ InstallationId = $reportingServicesData.Configuration.InstallationID } } Invoke-RsCimMethod @invokeRsCimMethodParameters if ( $PSBoundParameters.ContainsKey('UseSsl') -and $UseSsl -ne $currentConfig.UseSsl ) { New-VerboseMessage -Message "Changing value for using SSL to '$UseSsl'." $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'SetSecureConnectionLevel' Arguments = @{ Level = @(0,1)[$UseSsl] } } Invoke-RsCimMethod @invokeRsCimMethodParameters } Restart-ReportingServicesService -SQLInstanceName $InstanceName -WaitTime 30 } else { $getTargetResourceParameters = @{ InstanceName = $InstanceName DatabaseServerName = $DatabaseServerName DatabaseInstanceName = $DatabaseInstanceName } $currentConfig = Get-TargetResource @getTargetResourceParameters <# SQL Server Reporting Services virtual directories (both Report Server and Report Manager/Report Web App) are a part of SQL Server Reporting Services URL reservations. The default SQL Server Reporting Services URL reservations are: http://+:80/ReportServer/ (for Report Server) and http://+:80/Reports/ (for Report Manager/Report Web App) You can get them by running 'netsh http show urlacl' from command line. In order to change a virtual directory, we first need to remove existing URL reservations, change the appropriate virtual directory setting and re-add URL reservations, which will then contain the new virtual directory. #> if ( -not [System.String]::IsNullOrEmpty($ReportServerVirtualDirectory) -and ($ReportServerVirtualDirectory -ne $currentConfig.ReportServerVirtualDirectory) ) { New-VerboseMessage -Message "Setting report server virtual directory on $DatabaseServerName\$DatabaseInstanceName to $ReportServerVirtualDirectory." $currentConfig.ReportServerReservedUrl | ForEach-Object -Process { $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'RemoveURL' Arguments = @{ Application = 'ReportServerWebService' UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'SetVirtualDirectory' Arguments = @{ Application = 'ReportServerWebService' VirtualDirectory = $ReportServerVirtualDirectory Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters $currentConfig.ReportServerReservedUrl | ForEach-Object -Process { $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'ReserveUrl' Arguments = @{ Application = 'ReportServerWebService' UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } } if ( -not [System.String]::IsNullOrEmpty($ReportsVirtualDirectory) -and ($ReportsVirtualDirectory -ne $currentConfig.ReportsVirtualDirectory) ) { New-VerboseMessage -Message "Setting reports virtual directory on $DatabaseServerName\$DatabaseInstanceName to $ReportServerVirtualDirectory." $currentConfig.ReportsReservedUrl | ForEach-Object -Process { $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'RemoveURL' Arguments = @{ Application = $reportingServicesData.ReportsApplicationName UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'SetVirtualDirectory' Arguments = @{ Application = $reportingServicesData.ReportsApplicationName VirtualDirectory = $ReportsVirtualDirectory Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters $currentConfig.ReportsReservedUrl | ForEach-Object -Process { $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'ReserveUrl' Arguments = @{ Application = $reportingServicesData.ReportsApplicationName UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } } $compareParameters = @{ ReferenceObject = $currentConfig.ReportServerReservedUrl DifferenceObject = $ReportServerReservedUrl } if ( ($null -ne $ReportServerReservedUrl) -and ($null -ne (Compare-Object @compareParameters)) ) { $currentConfig.ReportServerReservedUrl | ForEach-Object -Process { $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'RemoveURL' Arguments = @{ Application = 'ReportServerWebService' UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } $ReportServerReservedUrl | ForEach-Object -Process { New-VerboseMessage -Message "Adding report server URL reservation on $DatabaseServerName\$DatabaseInstanceName`: $_." $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'ReserveUrl' Arguments = @{ Application = 'ReportServerWebService' UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } } $compareParameters = @{ ReferenceObject = $currentConfig.ReportsReservedUrl DifferenceObject = $ReportsReservedUrl } if ( ($null -ne $ReportsReservedUrl) -and ($null -ne (Compare-Object @compareParameters)) ) { $currentConfig.ReportsReservedUrl | ForEach-Object -Process { $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'RemoveURL' Arguments = @{ Application = $reportingServicesData.ReportsApplicationName UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } $ReportsReservedUrl | ForEach-Object -Process { New-VerboseMessage -Message "Adding reports URL reservation on $DatabaseServerName\$DatabaseInstanceName`: $_." $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'ReserveUrl' Arguments = @{ Application = $reportingServicesData.ReportsApplicationName UrlString = $_ Lcid = $language } } Invoke-RsCimMethod @invokeRsCimMethodParameters } } if ( $PSBoundParameters.ContainsKey('UseSsl') -and $UseSsl -ne $currentConfig.UseSsl ) { New-VerboseMessage -Message "Changing value for using SSL to '$UseSsl'." $invokeRsCimMethodParameters = @{ CimInstance = $reportingServicesData.Configuration MethodName = 'SetSecureConnectionLevel' Arguments = @{ Level = @(0,1)[$UseSsl] } } Invoke-RsCimMethod @invokeRsCimMethodParameters } } } if ( -not (Test-TargetResource @PSBoundParameters) ) { throw New-TerminatingError -ErrorType TestFailedAfterSet -ErrorCategory InvalidResult } } <# .SYNOPSIS Tests the SQL Reporting Services initialization status. .PARAMETER InstanceName Name of the SQL Server Reporting Services instance to be configured. .PARAMETER DatabaseServerName Name of the SQL Server to host the Reporting Service database. .PARAMETER DatabaseInstanceName Name of the SQL Server instance to host the Reporting Service database. .PARAMETER ReportServerVirtualDirectory Report Server Web Service virtual directory. Optional. .PARAMETER ReportsVirtualDirectory Report Manager/Report Web App virtual directory name. Optional. .PARAMETER ReportServerReservedUrl Report Server URL reservations. Optional. If not specified, http://+:80' URL reservation will be used. .PARAMETER ReportsReservedUrl Report Manager/Report Web App URL reservations. Optional. If not specified, 'http://+:80' URL reservation will be used. .PARAMETER UseSsl If connections to the Reporting Services must use SSL. If this parameter is not assigned a value, the default is that Reporting Services does not use SSL. #> function Test-TargetResource { [CmdletBinding()] [OutputType([System.Boolean])] param ( [Parameter(Mandatory = $true)] [System.String] $InstanceName, [Parameter(Mandatory = $true)] [System.String] $DatabaseServerName, [Parameter(Mandatory = $true)] [System.String] $DatabaseInstanceName, [Parameter()] [System.String] $ReportServerVirtualDirectory, [Parameter()] [System.String] $ReportsVirtualDirectory, [Parameter()] [System.String[]] $ReportServerReservedUrl, [Parameter()] [System.String[]] $ReportsReservedUrl, [Parameter()] [System.Boolean] $UseSsl ) $result = $true $getTargetResourceParameters = @{ InstanceName = $InstanceName DatabaseServerName = $DatabaseServerName DatabaseInstanceName = $DatabaseInstanceName } $currentConfig = Get-TargetResource @getTargetResourceParameters if ( -not $currentConfig.IsInitialized ) { New-VerboseMessage -Message "Reporting services $DatabaseServerName\$DatabaseInstanceName are not initialized." $result = $false } if ( -not [System.String]::IsNullOrEmpty($ReportServerVirtualDirectory) -and ($ReportServerVirtualDirectory -ne $currentConfig.ReportServerVirtualDirectory) ) { New-VerboseMessage -Message "Report server virtual directory on $DatabaseServerName\$DatabaseInstanceName is $($currentConfig.ReportServerVirtualDir), should be $ReportServerVirtualDirectory." $result = $false } if ( -not [System.String]::IsNullOrEmpty($ReportsVirtualDirectory) -and ($ReportsVirtualDirectory -ne $currentConfig.ReportsVirtualDirectory) ) { New-VerboseMessage -Message "Reports virtual directory on $DatabaseServerName\$DatabaseInstanceName is $($currentConfig.ReportsVirtualDir), should be $ReportsVirtualDirectory." $result = $false } $compareParameters = @{ ReferenceObject = $currentConfig.ReportServerReservedUrl DifferenceObject = $ReportServerReservedUrl } if ( ($null -ne $ReportServerReservedUrl) -and ($null -ne (Compare-Object @compareParameters)) ) { New-VerboseMessage -Message "Report server reserved URLs on $DatabaseServerName\$DatabaseInstanceName are $($currentConfig.ReportServerReservedUrl -join ', '), should be $($ReportServerReservedUrl -join ', ')." $result = $false } $compareParameters = @{ ReferenceObject = $currentConfig.ReportsReservedUrl DifferenceObject = $ReportsReservedUrl } if ( ($null -ne $ReportsReservedUrl) -and ($null -ne (Compare-Object @compareParameters)) ) { New-VerboseMessage -Message "Reports reserved URLs on $DatabaseServerName\$DatabaseInstanceName are $($currentConfig.ReportsReservedUrl -join ', ')), should be $($ReportsReservedUrl -join ', ')." $result = $false } if ( $PSBoundParameters.ContainsKey('UseSsl') -and $UseSsl -ne $currentConfig.UseSsl ) { New-VerboseMessage -Message "The value for using SSL are not in desired state. Should be '$UseSsl', but was '$($currentConfig.UseSsl)'." $result = $false } $result } <# .SYNOPSIS Returns SQL Reporting Services data: configuration object used to initialize and configure SQL Reporting Services and the name of the Reports Web application name (changed in SQL 2016) .PARAMETER InstanceName Name of the SQL Server Reporting Services instance for which the data is being retrieved. #> function Get-ReportingServicesData { [CmdletBinding()] [OutputType([System.Collections.Hashtable])] param ( [Parameter(Mandatory = $true)] [System.String] $InstanceName ) $instanceNamesRegistryKey = 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS' if ( Get-ItemProperty -Path $instanceNamesRegistryKey -Name $InstanceName -ErrorAction SilentlyContinue ) { $instanceId = (Get-ItemProperty -Path $instanceNamesRegistryKey -Name $InstanceName).$InstanceName $sqlVersion = [System.Int32]((Get-ItemProperty -Path "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$instanceId\Setup" -Name 'Version').Version).Split('.')[0] $reportingServicesConfiguration = Get-CimInstance -ClassName MSReportServer_ConfigurationSetting -Namespace "root\Microsoft\SQLServer\ReportServer\RS_$InstanceName\v$sqlVersion\Admin" $reportingServicesConfiguration = $reportingServicesConfiguration | Where-Object -FilterScript { $_.InstanceName -eq $InstanceName } <# SQL Server Reporting Services Web Portal application name changed in SQL Server 2016. https://docs.microsoft.com/en-us/sql/reporting-services/breaking-changes-in-sql-server-reporting-services-in-sql-server-2016 #> if ( $sqlVersion -ge 13 ) { $reportsApplicationName = 'ReportServerWebApp' } else { $reportsApplicationName = 'ReportManager' } } @{ Configuration = $reportingServicesConfiguration ReportsApplicationName = $reportsApplicationName } } <# .SYNOPSIS A wrapper for Invoke-CimMethod to be able to handle errors in one place. .PARAMETER CimInstance The CIM instance object that contains the method to call. .PARAMETER MethodName The method to call in the CIM Instance object. .PARAMETER Arguments The arguments that should be #> function Invoke-RsCimMethod { [CmdletBinding()] [OutputType([Microsoft.Management.Infrastructure.CimMethodResult])] param ( [Parameter(Mandatory = $true)] [Microsoft.Management.Infrastructure.CimInstance] $CimInstance, [Parameter(Mandatory = $true)] [System.String] $MethodName, [Parameter()] [System.Collections.Hashtable] $Arguments ) $invokeCimMethodParameters = @{ MethodName = $MethodName ErrorAction = 'Stop' } if ($PSBoundParameters.ContainsKey('Arguments')) { $invokeCimMethodParameters['Arguments'] = $Arguments } $invokeCimMethodResult = $CimInstance | Invoke-CimMethod @invokeCimMethodParameters <# Successfully calling the method returns $invokeCimMethodResult.HRESULT -eq 0. If an general error occur in the Invoke-CimMethod, like calling a method that does not exist, returns $null in $invokeCimMethodResult. #> if ($invokeCimMethodResult -and $invokeCimMethodResult.HRESULT -ne 0) { if ($invokeCimMethodResult | Get-Member -Name 'ExtendedErrors') { <# The returned object property ExtendedErrors is an array so that needs to be concatenated. #> $errorMessage = $invokeCimMethodResult.ExtendedErrors -join ';' } else { $errorMessage = $invokeCimMethodResult.Error } throw 'Method {0}() failed with an error. Error: {1} (HRESULT:{2})' -f @( $MethodName $errorMessage $invokeCimMethodResult.HRESULT ) } return $invokeCimMethodResult } Export-ModuleMember -Function *-TargetResource |