Microsoft SQL Server 2017 Reporting Services Silent Install (How-To Guide)

Microsoft SQL Server 2017 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 2017 Reporting Services from the command line using the EXE installer.

How to Install Microsoft SQL Server 2017 Reporting Services Silently

Microsoft SQL Server 2017 Reporting Services Silent Install (EXE)

  1. Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=55252
  2. Download & Copy the SQLServerReportingServices.exe to a folder created at (C:\Downloads)
  3. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  4. Navigate to the C:\Downloads folder
  5. 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 2017 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=55252
PowerShell Script:https://silentinstallhq.com/microsoft-sql-server-2017-reporting-services-install-and-uninstall-powershell/
Detection Script:https://silentinstallhq.com/create-a-custom-detection-script-for-microsoft-sql-server-2017-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 2017 Reporting Services Installation Log File

The Microsoft SQL Server 2017 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 2017 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 2017 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 2017 Reporting Services to “C:\Program Files\SSRS”

SQLServerReportingServices.exe /quiet /norestart /InstallFolder="C:\Program Files\SSRS" /IAcceptLicenseTerms /Edition=Dev

Set Custom Microsoft SQL Server 2017 Reporting Services License Key

Microsoft SQL Server 2017 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

https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/find-reporting-services-product-key-ssrs?view=sql-server-ver16

Set Custom Microsoft SQL Server 2017 Reporting Services Edition

In this example, I’m installing Microsoft SQL Server 2017 Reporting Services with the Eval Edition (Options are Dev, Eval, ExprAdv)

SQLServerReportingServices.exe /quiet /norestart /IAcceptLicenseTerms /Edition=Eval

How to Uninstall Microsoft SQL Server 2017 Reporting Services Silently

Check out the following posts for a scripted solution:

Microsoft SQL Server 2017 Reporting Services Install and Uninstall (PowerShell)
Microsoft SQL Server 2017 Reporting Services Silent Uninstall (PowerShell)
  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter the following commands:

Microsoft SQL Server 2017 Reporting Services Silent Uninstall (EXE)

"%ProgramData%\Package Cache\{23d65fd5-d1ea-42b4-a9c5-f827c468d788}\SQLServerReportingServices.exe" /uninstall /quiet /norestart

Microsoft System CLR Types for SQL Server 2017 Silent Uninstall (MSI)

MsiExec.exe /x {AC92C896-149B-4254-80CF-D1FC8BF4E831} /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.

Jason Bergner

I am an accomplished Software Engineer at Patch My PC, leveraging more than 18 years of hands-on experience in Configuration Manager administration and application packaging. I am driven by a genuine passion for solving complex problems and consistently strive to discover innovative and effective solutions. Sharing my extensive knowledge of application deployments is a true joy for me, and I am honored to contribute to the community here at Silent Install HQ.

Recent Posts