How to Install SQL Server Reporting Services 2019

Posted in: Microsoft SQL Server
sql server reporting

 

Problem

You’re trying to install SQL Server 2019 and when you reach the feature selection SSRS is nowhere to be found. You also get this notification banner below:

 

Cause

SSRS installation has been separated from Microsoft SQL Server installer for SQL Server 2019. It can be downloaded separately from this page.

Solution

Note:  It is not required to have the Database Engine on the same server where you are installing SSRS but it will need a SQL Server Instance where the Report Server databases will be hosted. It is not required during installation but you’ll need that information once you configure your SSRS.

  1. Download the SSRS installer from Microsoft Download Center.
  2. Locate your downloaded installer file and launch the SQLServerReportingServices.exe. This will launch the splash screen below. Choose Install Reporting Services:

3. On the next screen you would need to choose either the free versions–Developer Edition or Trial version–or enter your product key:

Where is my product key?
If you want to install a license version of SSRS, you can grab the product key from your SQL Server 2019 Installer. You can find the product key under the PID key in the x64\DefaultSetup.ini  file within the installation files. Or just launch the installer as if you are installing a new SQL instance and grab the product key from the product key step.

 

4. After clicking Next, you will see the license terms. Click on I accept the license terms then click next to continue:

5. Choose to install reporting services only, then click Next:

6. On the next screen, you can specify the install location or accept the default then click Install:

7. That is all the information that the installer requires to perform the installation. The next screen will show the progress of the installation:

8. Once completed, the installation will display the setup completed screen. You can choose to simply close the installer or go directly to Report Configuration Manager by clicking on Configure report server:

You can then proceed and configure SSRS the same way as previous versions on the Report Server Configuration Manager.

For more information on SSRS and how to install them, you can check it out further here.

 

 

email

Author

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Lead Microsoft Data Platform Consultant
Pio Balistoy is a Microsoft MVP for Data Platform from Singapore. He has been a Database professional for more than 17 years. He brings his passion for SQL to the community by being one of the Community leads for both Philippine Data Platform Forums (formerly Philippine SQL Server User Group) and Singapore SQL PASS.

4 Comments. Leave new

Awesome instructions! Thank you!

Reply

Thank you!

Reply

I have installed this on a server, separate from the SQL Server database. The database is SQL Server 2017 and the SSMS will not accept the Product Key from that installation. How do I get a Key that will work? Thank you.

Reply

Hi David do you mean you want to install SQL Server Reporting Services 2019 with a SQL Server 2017 Database Engine product Key? You’ll need a license key for the same version of SQL Server. If you mean you are installing SSMS – SQl Server Management Studio, you don’t need a license key for that if you install the latest version. SSMS after 2017 is already separate from SQL Server Installation media. YOu can find the download link here https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *