Functions/Utilities/Connect-RsReportServer.ps1
|
# Copyright (c) 2017 Friedrich Weinmann. All Rights Reserved. # Licensed under the MIT License (MIT) function Connect-RsReportServer { <# .SYNOPSIS Connects to a Reporting Server .DESCRIPTION This function can be used to specify default connection information to connect to a Reporting Server, both using WMI or WebProxy. .PARAMETER ComputerName The name of the computer to connect via WMI to. Only used for WMI access. .PARAMETER ReportServerInstance The name of the SQL Instance to connect via WMI to. Only used for WMI access. .PARAMETER ReportServerVersion The version of the SQL Server whose reporting services you connect to via WMI to. Only used for WMI access. .PARAMETER Credential The credentials used to execute all requests. Null it in order to use your current user's credentials. Used both for WMI access as well as WebApi access. .PARAMETER ReportServerUri The Uri to connect to for accessing the SOAP Endpoint. .PARAMETER ReportPortalUri The Uri to connect to for accessing the REST Endpoint. This exists in SQL Server Reporting Services 2016 and later. .PARAMETER SoapEndpointApiVersion The version of the API to use, 2010 by default. Sepcifiy '2005' or '2006' if you need to query a Sql Server Reporting Service Instance running a version prior to SQL Server 2008 R2 to access those respective APIs. .EXAMPLE Connect-RsReportServer -ComputerName "srv-foobar" -ReportServerInstance "Northwind" -ReportServerUri "http://srv-foobar/reportserver/" Configures WMI access to - Target the server "srv-foobar" - Target the Instance "Northwind" Configures WebApi access to - Connect to the Uri: "http://srv-foobar/reportserver/" #> [CmdletBinding()] param ( [AllowEmptyString()] [AllowNull()] [string] $ComputerName, [Alias('SqlServerInstance')] [string] $ReportServerInstance, [Alias('SqlServerVersion')] [Microsoft.ReportingServicesTools.SqlServerVersion] $ReportServerVersion, [AllowEmptyString()] [AllowNull()] [PSCredential] $Credential, [Alias('Uri')] [string] $ReportServerUri, [string] $ReportPortalUri, [switch] $RegisterProxy, [ValidateSet('2005','2006','2010')] [string] $SoapEndpointApiVersion = '2010' ) if ($PSBoundParameters.ContainsKey("ComputerName")) { [Microsoft.ReportingServicesTools.ConnectionHost]::ComputerName = $ComputerName } if ($PSBoundParameters.ContainsKey("ReportServerInstance")) { [Microsoft.ReportingServicesTools.ConnectionHost]::Instance = $ReportServerInstance } if ($PSBoundParameters.ContainsKey("ReportServerVersion")) { [Microsoft.ReportingServicesTools.ConnectionHost]::Version = $ReportServerVersion } if ($PSBoundParameters.ContainsKey("Credential")) { [Microsoft.ReportingServicesTools.ConnectionHost]::Credential = $Credential } if ($PSBoundParameters.ContainsKey("ReportServerUri")) { [Microsoft.ReportingServicesTools.ConnectionHost]::ReportServerUri = $ReportServerUri try { $proxy = New-RsWebServiceProxy -ReportServerUri ([Microsoft.ReportingServicesTools.ConnectionHost]::ReportServerUri) -Credential ([Microsoft.ReportingServicesTools.ConnectionHost]::Credential) -ApiVersion $SoapEndpointApiVersion -ErrorAction Stop [Microsoft.ReportingServicesTools.ConnectionHost]::Proxy = $proxy } catch { throw (New-Object System.Exception("Failed to establish proxy connection to $ReportServerUri : $($_.Exception.Message)", $_.Exception)) } } if ($PSBoundParameters.ContainsKey("ReportPortalUri")) { [Microsoft.ReportingServicesTools.ConnectionHost]::ReportPortalUri = $ReportPortalUri } } |