SQL Server Reporting Services (SSRS)

 

What is SQL Server Reporting Services (SSRS)?

SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage reports. You can design reports using data, tables, graphs, charts, and images. You can easily deploy reports on the local or remote server.

Step 1

Let us first download installation media for SSRS. To download compatible installation media first run SQL Server Setup as shown in this article. Go to the Install SQL Server 2019 Developer Edition section of the article and follow steps 1 and 2. You will see the below screen. Now click on the Install SQL Server Reporting Services link and it will launch a download page for SSRS. Download installation media for SSRS report from that page

Step 2

Now double click and run the downloaded installation media. You will see the below screen. Click on the Install Reporting Services button.

Step 3

It will start the installation of SSRS which will take some time.

Step 4

Next, you will see the configuration wizard. First, you need to connect an SQL server instance for which you want to configure SSRS. Select an instance and click on the Connect button.

Step 5

Next click on the Service Account tab from the left panel. You will see the service account configuration window. Specify windows account to run the report server service. I recommend creating a new dedicated user with administrator privileges for this. I have created one with the name ReportAdmin. Enter your account and password and click on Apply button. It will configure the service account.

Step 6

Next click on the Web Service URL tab from the left panel. Here you can configure the report server URL. We will use this URL to deploy SSRS reports on the report server. You can also configure ports (80 or 443 (SSL)) on which the report server will host. It will preview URLs in the bottom section. I will go with default settings. Click on the Apply button and it will configure the report server web service URL.

Step 7

Next click on the Database tab from the left panel. Here we will configure the database for the report server. Click on the Change Database button.

.