Microsoft SQL Server 2022 Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality. This article will serve as an informative guide and give you a clear understanding of how to perform a silent installation of Microsoft SQL Server 2022 Reporting Services from the command line using the EXE installer.
How to Install Microsoft SQL Server 2022 Reporting Services Silently
Microsoft SQL Server 2022 Reporting Services Silent Install (EXE)
- Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=104502
- Download & Copy the SQLServerReportingServices.exe to a folder created at (C:\Downloads)
- Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
- Navigate to the C:\Downloads folder
- Enter the following command:
SQLServerReportingServices.exe /quiet /norestart /IAcceptLicenseTerms /Edition=Dev |
After a few moments you will find Microsoft SQL Server Reporting Services entries in the Start Menu, Installation Directory, and Programs and Features in the Control Panel.
| Software Title: | Microsoft SQL Server 2022 Reporting Services |
| Vendor: | Microsoft Corporation |
| Architecture: | x86_x64 |
| Installer Type: | EXE |
| Silent Install Switch: | SQLServerReportingServices.exe /quiet /norestart /IAcceptLicenseTerms /Edition=Dev |
| Silent Uninstall Switch: | SQLServerReportingServices.exe /uninstall /quiet /norestart |
| Repair Command: | SQLServerReportingServices.exe /repair /quiet /norestart |
| Download Link: | https://www.microsoft.com/en-us/download/details.aspx?id=104502 |
| PowerShell Script: | https://silentinstallhq.com/microsoft-sql-server-2022-reporting-services-install-and-uninstall-powershell/ |
| Detection Script: | https://silentinstallhq.com/create-a-custom-detection-script-for-microsoft-sql-server-2022-reporting-services-powershell/ |
The information above provides a quick overview of the software title, vendor, silent install, and silent uninstall switches. The download links provided take you directly to the vendors website. Continue reading if you are interested in additional details and configurations.
Additional Configurations
Create a Microsoft SQL Server 2022 Reporting Services Installation Log File
The Microsoft SQL Server 2022 Reporting Services installer offers the option to generate a log file during installation to assist with troubleshooting should any problems arise. You can use the following command to create a verbose log file with details about the installation.
Microsoft SQL Server 2022 Reporting Services Silent Install (EXE) with Logging
SQLServerReportingServices.exe /quiet /norestart /IAcceptLicenseTerms /Edition=Dev /log "%WINDIR%\Temp\SSRS-Install.log" |
Change the Microsoft SQL Server 2022 Reporting Services Default Install Directory
You can also change the default installation directory by using the following command line parameters. In this example, I’m installing Microsoft SQL Server 2022 Reporting Services to “C:\Program Files\SSRS”
SQLServerReportingServices.exe /quiet /norestart /InstallFolder="C:\Program Files\SSRS" /IAcceptLicenseTerms /Edition=Dev |
Set Custom Microsoft SQL Server 2022 Reporting Services License Key
Microsoft SQL Server 2022 Reporting Services Silent Install with License Key
SQLServerReportingServices.exe /quiet /norestart /PID=XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /IAcceptLicenseTerms /Edition=Dev |
How to Find the Product Key for SQL Server Reporting Services
Set Custom Microsoft SQL Server 2022 Reporting Services Edition
In this example, I’m installing Microsoft SQL Server 2022 Reporting Services with the Eval Edition (Options are Dev, Eval, ExprAdv)
SQLServerReportingServices.exe /quiet /norestart /IAcceptLicenseTerms /Edition=Eval |
How to Uninstall Microsoft SQL Server 2022 Reporting Services Silently
Check out the following posts for a scripted solution:
| Microsoft SQL Server 2022 Reporting Services Install and Uninstall (PowerShell) |
| Microsoft SQL Server 2022 Reporting Services Silent Uninstall (PowerShell) |
- Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
- Enter the following commands:
Microsoft SQL Server 2022 Reporting Services Silent Uninstall (EXE)
"%ProgramData%\Package Cache\{578c86e2-1849-4c3b-bbe1-9e1e38fcfce6}\SQLServerReportingServices.exe" /uninstall /quiet /norestart |
Microsoft System CLR Types for SQL Server 2019 CTP3.0 Silent Uninstall (MSI)
MsiExec.exe /x {95F92233-C25F-4722-B43B-3F736459DA3F} /qn |
Active Directory Authentication Library for SQL Server Silent Uninstall (MSI)
MsiExec.exe /x {AA4514EC-4DB3-43F9-9FB8-C3C0C720D1D6} /qn |
Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.