Commands / Set-sqmSsrsConfiguration
Configuration

Set-sqmSsrsConfiguration

Fully configures SQL Server Reporting Services (SSRS) or Power BI Report Server, service account, ReportServer database, URLs, and encryption key backup, via WMI. Supports Native Mode, AlwaysOn listeners, and individual step skipping.

Module: sqmSQLTool
Requires: dbatools + WMI (ReportingService)
ShouldProcess: Yes (Medium)
Output: PSCustomObject

Execution Flow

START Connect to WMI ReportingService on ComputerName -PbmPolicyName given? Disable PBM policy before DB create -SkipServiceAccount? Yes (skip) No SetWindowsServiceIdentity (service account) -SkipDatabase? Yes (skip) Create ReportServer DB + grant permissions + set connection -SkipUrls? Yes (skip) ReserveUrl ReportServer + Reports (Web Service + Portal) -SkipEncryptionKeyBackup? Yes (skip) BackupEncryptionKey → EncryptionKeyFile (.snk) Re-enable PBM policy (if disabled) → Return PSCustomObject DONE
Each configuration area (service account, database, URLs, encryption key) can be skipped independently with the matching -Skip* switch. For AlwaysOn, set -DatabaseServer to the AG listener, the DB is created on the primary and SSRS connects via the listener. SQL auth is supported via -DatabaseAuthType SQL + -DatabaseCredential.

Parameters

ParameterTypeRequiredDescription
-ComputerNameStringOptionalSSRS server (local or remote). Default: $env:COMPUTERNAME.
-InstanceNameStringOptionalSSRS instance name. Default: MSSQLSERVER.
-DatabaseServerStringOptionalSQL Server instance or AG listener for the ReportServer database. Default: ComputerName.
-DatabaseNameStringOptionalReportServer database name. Default: ReportServer.
-ReportServerUrlStringOptionalWeb Service URL. Default: http://+:80/ReportServer.
-ReportsUrlStringOptionalWeb Portal URL. Default: http://+:80/Reports.
-ServiceAccountStringOptionalWindows service account for SSRS (e.g. DOMAIN\user).
-ServiceAccountPasswordSecureStringOptionalPassword for -ServiceAccount. Not needed for managed service accounts.
-DatabaseAuthTypeStringOptionalWindows (default) or SQL.
-DatabaseCredentialPSCredentialOptionalSQL credential for -DatabaseAuthType SQL.
-EncryptionKeyFileStringOptionalPath for the encryption key backup (.snk). Default: OutputPath\SsrsEncryptionKey_*.snk.
-EncryptionKeyPasswordSecureStringOptionalPassword for the encryption key backup.
-PbmPolicyNameStringOptionalPBM policy to disable before DB creation and re-enable after.
-SkipDatabaseSwitchOptionalSkip database creation/configuration step.
-SkipUrlsSwitchOptionalSkip URL reservation step.
-SkipServiceAccountSwitchOptionalSkip service account configuration step.
-SkipEncryptionKeyBackupSwitchOptionalSkip encryption key backup step.
-OutputPathStringOptionalDirectory for the encryption key backup file.
-CredentialPSCredentialOptionalCredential for remote WMI connection to ComputerName.
-EnableExceptionSwitchOptionalThrow terminating errors instead of logging warnings.
-ContinueOnErrorswitchOptionalContinue with the remaining items instead of aborting on the first error.

Return Value

Returns a PSCustomObject with: ComputerName, InstanceName, DatabaseServer, DatabaseName, ReportServerUrl, ReportsUrl, EncryptionKeyFile, Status, Message.

Examples

Example 1, Full auto-configuration on local server

Set-sqmSsrsConfiguration -ServiceAccount "DOMAIN\svc-ssrs" -ServiceAccountPassword $pw

Example 2, Remote server with AG listener as DB backend

Set-sqmSsrsConfiguration -ComputerName "SSRS01" -DatabaseServer "AG-Listener" -Credential $cred

Example 3, Only reconfigure URLs (skip all other steps)

Set-sqmSsrsConfiguration -SkipServiceAccount -SkipDatabase -SkipEncryptionKeyBackup `
    -ReportServerUrl "http://+:8080/ReportServer" -ReportsUrl "http://+:8080/Reports"
⬆ Index
All Commands