Commands / Install-sqmSsrsReportServer
Install-sqmSsrsReportServer
ConfigurationsqmSQLTool v1.8.2+ · SSRS Setup⚠ Admin Required  •  ShouldProcess High  •  Remote Support
Installs SQL Server Reporting Services 2022 silently from a network share. Three-phase execution: [1] Prerequisites (admin rights, installer file, SSRS not already present), [2] Silent install (EXE or MSI, copies to local temp first, waits for WMI namespace), [3] Automatic configuration via Set-sqmSsrsConfiguration with parameter splatting. Supports -SkipConfiguration and -Force for re-installation.

Execution Flow

START Resolve InstallerPath -InstallerPath || Get-sqmConfig 'SsrsInstallerPath' No path configured throw / Write-Error File accessible? Test-Path installer NO File not found throw / Write-Error YES ▼ Admin rights? isLocal check only NO No local admin throw / Write-Error YES ▼ SSRS already installed? YES -Force → continue else → skip install NO ▼ ShouldProcess ConfirmImpact: High WhatIf InstallResult=WhatIf return result Confirm ▼ Copy installer → %TEMP%\SsrsInstall_* UNC paths cannot be started as process directly EXE or MSI? .exe /quiet /IAcceptLicense /Edition= or /PID= .msi msiexec /quiet /norestart EDITION= Start-Process -Wait -PassThru Silent installation running... ExitCode? 0 / 3010 / other other throw InstallFailed return result 3010 RebootRequired=$true InstallResult=OK 0=OK ▼ Wait for SSRS WMI namespace (max WmiWaitSeconds) root\Microsoft\SqlServer\ReportServer · poll every 3s -SkipConfiguration? YES return result ConfigResult=Skipped NO ▼ Set-sqmSsrsConfiguration @configSplat DB · URLs · ServiceAccount · EncryptionKey · SkipXxx flags Return [PSCustomObject] OverallStatus · InstallResult · ConfigResult · RebootRequired DONE

Parameters

ParameterTypeRequiredDefaultNotes
-ComputerNamestringOptional$env:COMPUTERNAMETarget computer. Remote via WinRM.
-InstallerPathstringOptionalGet-sqmConfig 'SsrsInstallerPath'UNC or local path to .exe or .msi installer.
-EditionstringOptionalDeveloperEval | Developer | Expr | Web | Standard | Enterprise.
-ProductKeystringOptional—25-char product key. Overrides -Edition if set.
-ForceswitchSwitch$falseInstall even if SSRS already present.
-SkipConfigurationswitchSwitch$falseInstall only; skip Set-sqmSsrsConfiguration call.
-WmiWaitSecondsintOptional60Max wait seconds for SSRS WMI namespace after install.
-InstanceNamestringOptionalMSSQLSERVERSSRS instance. Passed to Set-sqmSsrsConfiguration.
-DatabaseServerstringOptional—SQL Server for ReportServer database.
-DatabaseNamestringOptionalReportServerReportServer database name.
-ReportServerUrlstringOptionalhttp://+:80/ReportServerURL for the ReportServer web service.
-ReportsUrlstringOptionalhttp://+:80/ReportsURL for the reports portal.
-ServiceAccountstringOptional—Windows service account for SSRS.
-SkipDatabaseswitchSwitch$falseSkip database configuration.
-SkipUrlsswitchSwitch$falseSkip URL configuration.
-SkipEncryptionKeyBackupswitchSwitch$falseSkip encryption key backup.
-CredentialPSCredentialOptional—WinRM credentials for remote access.
-ContinueOnErrorswitchSwitch$falseTreat configuration errors as non-terminating.
-EnableExceptionswitchSwitch$falseRe-throw exceptions immediately.

Examples

Install SSRS using the configured installer path (Developer edition)
Install-sqmSsrsReportServer
Full remote install with product key and AG listener as DB server
Install-sqmSsrsReportServer `
    -InstallerPath '\\fileserver\sql\SSRS2022\SQLServerReportingServices.exe' `
    -Edition Standard `
    -DatabaseServer 'SQL-AG-Listener' `
    -ServiceAccount 'DOMAIN\svc_ssrs' `
    -EncryptionKeyPassword (Read-Host -AsSecureString 'Key-Password')
WhatIf — preview without making changes
Install-sqmSsrsReportServer -SkipConfiguration -WhatIf
← Back
Command Index