Introduction
In this article, we are going to configure Microsoft SQL Server Reporting Services on the windows machine.
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.
Pre-requisites
- Microsoft SQL Server installed on the machine (please check my article to install SQL Server here).
- Configure Named Pipe and TCP/IP Settings if your SQL Server Database Engine Instance is hosted on another machine (please check my article here).
Install SQL Server Reporting Services (SSRS)
Let us install and configure SQL Server Reporting Services on the local machine.
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
Next, you will see the below screen. Choose Express or Developer edition from Choose a free edition dropdown and click on the Next button.

Step 4
On the next screen, simply accept the license terms and click on the Next button.

Step 5
Now Install Reporting Services only option is already selected so just click on the Next button.

Step 6
Choose the installation location of your choice. I will go with the default location. Click on the Install button.

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

Step 8
Once the installation is finished, click on the Configure report server button, or if you want to install it later simply click on the Close button.

Great! We have successfully installed SQL Server Reporting Services. I recommend restarting your machine before configuring it.
Configure SQL Server Reporting Services
Now that you have installed SQL Server Reporting Services, let us configure it.
Step 1
Open Report Server Configuration Manager from the Start menu.

Step 2
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 3
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.














Sampath MayinkarPosted Sep 22, 2022, 9:50 AM
Hi, i configured as above , but still it is asking to enter the User name and password.
Sagar LadPosted Oct 30, 2021, 7:24 AM
Nice article