SQL Server Reporting Services installation involves server components for storing report items, rendering reports, and processing of subscription and other report services 


Prerequisites: SQL Server Standard edition. 

Installing a report server is straightforward. There are only a few steps to install the files.

 

Step-1: Open the below link and download SQL Server Reporting service 2019.

               https://www.microsoft.com/en-us/download/details.aspx?id=100122    


 Step-2: Right-click on the downloaded executable file and select “Run as Administrator”, the below window will open.

 

 

 

 Step-3: Select the developer free edition and click on Next



 

Step-4: Select the License and terms and click on Next


 

 

Step-5: Install Reporting service only click on next.


 

Step-6: Select Installation location and click on Install


 

 

 Step-7: After installation will complete, click on the Configure report server button


 

Step-8: Report Server Configuration window will open. Click on the find to find the available server and click on connect.


 

 

Step-9: In Configuration Manager Click on the “Web service URL tab” then Click on apply.



 

Step-10: Click on Web portal URL and click on Apply



 

Step-11: Click on the Database link and click on change Database, new Change database window will open.



 

Step-12: Select Create new report server database then click on Next


 

 

 Step-13: Give the SQL database server name, user id and password then test the connection, if the connection succeeds then click on next.


 

 

Step-14: Leave the database name as it is “Report server” then click on next


 


Step-15: Give the SQL user id and password again and click on Next


 

 

Step-16: Click on Next, it will create a report server database and configure it.



 

Step-17:


 


Step-18: After finishing report server configuration click on the Web portal URL and click on the given link


 

 

 Step-19: If the below window will open in the browser then SSRS configured successfully (Sometimes it will ask you to use windows login credential for login).