Get‑SqlDscRSSslCertificateBinding

SYNOPSIS

Gets SSL certificate bindings for SQL Server Reporting Services.

SYNTAX

Get-SqlDscRSSslCertificateBinding [-Configuration] <Object> [[-Lcid] <Int32>]
 [<CommonParameters>]

DESCRIPTION

Gets the SSL certificate bindings for SQL Server Reporting Services or Power BI Report Server by calling the ListSSLCertificateBindings method on the MSReportServer_ConfigurationSetting CIM instance.

This command retrieves information about which SSL certificates are bound to the Reporting Services instance and on which IP addresses and ports.

The configuration CIM instance can be obtained using the Get-SqlDscRSConfiguration command and passed via the pipeline.

EXAMPLES

EXAMPLE 1

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Get-SqlDscRSSslCertificateBinding

Gets all SSL certificate bindings for the Reporting Services instance 'SSRS'.

EXAMPLE 2

$config = Get-SqlDscRSConfiguration -InstanceName 'SSRS'
Get-SqlDscRSSslCertificateBinding -Configuration $config -Lcid 1033

Gets all SSL certificate bindings with a specific LCID.

PARAMETERS

-Configuration

Specifies the MSReportServer_ConfigurationSetting CIM instance for the Reporting Services instance. This can be obtained using the Get-SqlDscRSConfiguration command. This parameter accepts pipeline input.

Type: Object
Parameter Sets: (All)
Aliases:

Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: False

-Lcid

Specifies the language code identifier (LCID) for the request. If not specified, defaults to the operating system language. Common values include 1033 for English (US).

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: 2
Default value: 0
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

Microsoft.Management.Infrastructure.CimInstance

Accepts MSReportServer_ConfigurationSetting CIM instance via pipeline.

OUTPUTS

System.Management.Automation.PSCustomObject

Returns objects with properties: Application, CertificateHash, IPAddress,

Port, and Lcid.

NOTES

This command calls the WMI method ListSSLCertificateBindings.

RELATED LINKS

https://docs.microsoft.com/en-us/sql/reporting-services/wmi-provider-library-reference/configurationsetting-method-listsslcertificatebindings