Set-sqmSsrsHttpsCertificate
Examples
Set-sqmSsrsHttpsCertificate -Thumbprint "A1B2C3D4E5F6A1B2C3D4E5F6A1B2C3D4E5F6A1B2"
Set-sqmSsrsHttpsCertificate -Thumbprint "A1B2C3D4E5F6A1B2C3D4E5F6A1B2C3D4E5F6A1B2" Binds the specified certificate to SSRS on the local machine on port 443. The SSRS instance is auto-detected.
Set-sqmSsrsHttpsCertificate -ComputerName "REPSERVER01" -Thumbprint "A1B2C3D4E5F6A1B2C3D4E5F6A1B2C3D4E5F6A1B2" -Port 8443 -InstanceName "RS_PBIRS" -RequireSSL
Set-sqmSsrsHttpsCertificate -ComputerName "REPSERVER01" -Thumbprint "A1B2C3D4E5F6A1B2C3D4E5F6A1B2C3D4E5F6A1B2" -Port 8443 -InstanceName "RS_PBIRS" -RequireSSL Binds the certificate to Power BI Report Server on REPSERVER01, port 8443, and requires HTTPS (SecureConnectionLevel = 1).
$cred = Get-Credential
$cred = Get-Credential Set-sqmSsrsHttpsCertificate -ComputerName "REPSERVER02" -Thumbprint "A1B2C3D4E5F6A1B2C3D4E5F6A1B2C3D4E5F6A1B2" -Credential $cred -WhatIf Shows what changes would be made on REPSERVER02 without applying them.
Get-sqmTsmConfiguration -ComputerName SQL01
Get-sqmTsmConfiguration -ComputerName SQL01
# Reads the TSM configuration from SQL01 (password as SecureString).
Get-sqmTsmConfiguration -DsmOptPath 'C:\Program Files\Tivoli\TSM\baclient\dsm.opt' -IncludePasswordPlain
Get-sqmTsmConfiguration -DsmOptPath 'C:\Program Files\Tivoli\TSM\baclient\dsm.opt' -IncludePasswordPlain
# Uses an explicit dsm.opt path and also returns the plain-text password.