In this article we are going to learn how to install SQL Server Reporting Services.
To begin with, we may first define what SQL Server Reporting Services means?
SQL Server Reporting Services commonly known as SSRS, is basically a collection of on-premises tools and services for creation, deployment and management of reports. These reports can be created by utilizing information from tables, graphs, charts & photographs which can be deployed on both local and remote servers.
SSRS needs to be installed separately from Microsoft SQL Server Installer for SQL Server 2019. And you can download it from Microsoft SSRS 2019.
After the installer file is downloaded, you will need to run SQLServerReportingServices.exe. Once the installation begins, the following screen will appear where you choose Install Reporting Services as your selection to begin the procedure.
You must either select the free versions (Developer Edition or Trial edition) or enter your product key on the following screen. I will be using the ‘Evaluation’ version; this basically has all the features of an Enterprise edition version but as mentioned it’s valid for a trial period of 180 days.
Once you click Next, the licensing conditions appear; agree to the licensing conditions and then click Next to proceed.
Choose to install reporting services only, then click Next:
On the next screen, you can specify the install location or accept the default then click Install:
And that’s all the information that the installer needs to complete the installation. The next screen will indicate the progress of your installation:
The setup completed screen will appear after the installation is finished. By selecting Configure report server, you may either opt to just close the installation or proceed straight to Report Configuration Manager.
Hope you find this article helpful and be able to successfully set up your SQL Server Reporting Services. It’s recommended that you restart your machine before heading to the configuration.