SQL Server Reporting Services Standalone Installation

By:   |   Comments (8)   |   Related: > Reporting Services Installation


Have you ever wanted to install SQL Server Reporting Services (SSRS) on its own? Have you ever needed a second reporting services machine?


Unbelievably, the changes and availability of features and options for SQL Server 2016 and beyond (vNext) just keep coming.  Several enterprise level features were made available in SQL Server 2016 SP1; if you are not familiar with these changes, please take a look at Aaron Bertrand’s tip on this very topic at:  New Features in SQL Server 2016 Service Pack 1.

Fortunately, SSRS was not left out of the mix of features completely (unfortunately, KPIs and Data Driven Subscriptions are still Enterprise only).  However, there are several “nuggets” of features in or coming to SQL Server Reporting Services, now or in the near future. Surprisingly, one of the most beneficial yet most overlooked new feature came with the January 2017 Technical Preview. You are now able to install SSRS as a "standalone" install. No need to have the full SQL Server install files anymore!

Lightweight Install

So you may be wondering what the benefit is of a standalone install. First and foremost, the install is smaller and easier to complete than a full SQL Server 2016 install. The install completes in less time and with a lower number of steps; further the install is part of the larger Power BI with SSRS integration. Of course, the process is not without a caveat or two. The biggest is that a SQL Server database is still required to complete the configuration of and host the databases for SSRS. The database engine is not needed during the install, but ultimately must be available during the configuration phase. We will discuss some of the other caveats later in this tip.

The initial install process for Standalone SSRS is a follows. First, the Reporting Services install file must be downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=55253. Note that this link also includes the Power BI Desktop install files as this version of Reporting Services allows for Power BI objects to be published to SSRS (that we will save for another tip!). In particular, you would want to download this file: SQLServerReportingServices.exe.

Next, you will begin the install process by clicking on the SQLServerReportingServices.exe; the below illustration shows the opening installation window.

SSRS Standalone - Description: SSRS standalone install screen 1.

You can, using the Options Button, adjust the install file location, if desired.

SSRS StandAlone Location - Description: Install location for SSRS sandalone.

The remainder of the install is fairly standard and is shown in the next set of screen shots.

SSRS Standalone Install - Description: Progress screen for SSRS Standalone install

Finally, the install is compete.

SSRS Standalone Finish - Description: Finish screen for SSRS Standalone.

Clicking on the Configure Report Server button opens the standard SSRS Configuration screen.

SSRS Configuration - Description: SSRS Configuration connection screen.

At this point, we can connect to the default instance (pre-filled) for this standalone installation. Clicking on Connect then allows for creating or connecting to any SSRS database. The configuration process is covered extensively in the tips found at: SQL Server Reporting Services Configuration Tips. Depending on your local environment, you may need to adjust the service account and / or instance used to create or connect to the SSRS databases (ReportServer and ReportServerTemp).

SSRS Configuration Manage - Description: Configuration Manager for SSRS Status screen

Lastly, we have a stand-alone, working SSRS instance that is connected to a backend SSRS database, which can be housed on any number of SQL Server machines you have in your server farm.

One other item you will also notice; a new SQL Server Reporting Services – Standalone service now exists on the machine where the install was completed.

Services - Description: SSRS Standalone Service

To Keep in Mind about the Stand Alone Install

Several items should be mentioned about the standalone SSRS install. First, the install needs to be completed using an account that has administrative privileges. Second, whatever account runs the SSRS configuration after the install must have been granted permissions to create a database on the desired SQL Server database server. The default virtual directories of Reports and ReportServer are automatically created during the install (similar to the full install); additionally, the default port of port 80 is automatically used for the SSRS website.  The system requirements for SQL Server are still in effect, so you should review the current system requirements at https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server. Certainly, not all the components are being installed and can be ignored, but those pertaining to SSRS must be taken into consideration.

Even with these limitations, the new SSRS Standalone install will be very advantageous for anyone needing to install many SSRS instances.

Next Steps

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Tuesday, February 11, 2020 - 6:06:44 PM - Priya Back To Top (84364)

ok thanks

Tuesday, February 11, 2020 - 9:34:10 AM - Scott Murray Back To Top (84341)

Yes you will need a license for it.

Monday, February 10, 2020 - 11:32:48 PM - Priya Back To Top (84318)

if i am going to install standalone SSRS on azure VM , do i need license for it. My data source will be sql managed instance, I just need azure vm to host SSRS.

Monday, December 4, 2017 - 9:43:13 AM - tims Back To Top (73607)



I try to install two instances of SSRS 2017 on the same server. But it's seem to be impossible. When I run ssrs installer it give me only 3 choices (upgrade the edition, Repair, Uninstall).

Someone know how to do ?

Tuesday, September 12, 2017 - 6:01:27 PM - Scott Murray Back To Top (66211)

Ed... these options and tools are moving at the speed of light.  

This option is now rolled under Power BI. This link may be helpful:





Tuesday, September 12, 2017 - 4:46:00 PM - Ed Back To Top (66208)

 The link, https://www.microsoft.com/en-us/download/details.aspx?id=55253 doesnt work, and trying to find just 2016 SSRS seems to redirect you to SSRS 2017 (RC) which is not what I need.

Any idea of the correct link for 2016 SSRS?


Thanks again.


Monday, June 5, 2017 - 3:04:30 PM - Scott Murray Back To Top (56792)

Thanks Anne... they must have changed it.. Can you try:  https://www.microsoft.com/en-us/download/details.aspx?id=55253


Monday, June 5, 2017 - 2:05:58 PM - Anne Back To Top (56788)

Thanks for the article, I tried the download link, it is not there anymore.



get free sql tips
agree to terms