Install SQL Server Reporting Services
THIS TOPIC APPLIES TO: SQL Server Reporting Services (2017 and later) Power BI Report Server
SQL Server Reporting Services installation involves server components for storing report items, rendering reports, and processing of subscription and other report services. Learn how to install Power BI Report Server.
To download SQL Server 2017 Reporting Services, go to the Microsoft Download Center.
Looking for Power BI Report Server? See Install Power BI Report Server.
Before you begin
Before you install Reporting Services, review the Hardware and software requirements for installing SQL Server.
Install your report server
Installing a report server is straight forward. There are only a few steps to install the files.
You do not need a SQL Server Database Engine server available at the time of install. You will need one to configure Reporting Services after install.
Find the location of SQLServerReportingServices.exe and launch the installer.
Select Install Reporting Services.
Choose an edition to install and then select Next.
You can choose either Evaluation or Developer edition from the drop down.
Otherwise, you can enter a product key.
Read and agree to the license terms and conditions and then select Next.
You need to have a Database Engine available to store the report server database. Select Next to install the report server only.
Specify the install location for the report server. Select Install to continue.
The default path is C:\Program Files\Microsoft SQL Server Reporting Services.
After a successful setup, select Configure Report Server to launch the Reporting Services Configuration Manager.
Configuration your report server
After you select Configure Report Server in the setup, you will be presented with Report Server Configuration Manager. For more information, see Report Server Configuration Manager.
You need to create a report server database to complete the initial configuration of Reporting Services. A SQL Server Database server is required to complete this step.
Creating a database on a different server
If you are creating the report server database on a database server on a different machine, you need to change the service account for the report server to a credential that is recognized on the database server.
By default, the report server uses the virtual service account. If you try to create a database on a different server, you may receive the following error on the Applying connection rights step.
System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group '(null)' not found. Check the name again.
To work around the error, you can change the service account to either Network Service or a domain account. Changing the service account to Network Service applies rights in the context of the machine account for the report server.
For more information, see Configure the report server service account.
A windows service is created as part of the installation. It is displayed as SQL Server Reporting Services. The service name is SQLServerReportingServices.
Default URL reservations
URL reservations are composed of a prefix, host name, port, and virtual directory:
|Prefix||The default prefix is HTTP. If you previously installed a Secure Sockets Layer (SSL) certificate, Setup tries to create URL reservations that use the HTTPS prefix.|
|Host name||The default host name is a strong wildcard (+). It specifies that the report server accepts any HTTP request on the designated port for any host name that resolves to the computer, including
|Port||The default port is 80. If you use any port other than port 80, you have to explicitly add it to the URL when you open web portal in a browser window.|
|Virtual directory||By default, virtual directories are created in the format of ReportServer for the Report Server Web service and Reports for the web portal. For the Report Server Web service, the default virtual directory is reportserver. For the web portal, the default virtual directory is reports.|
An example of the complete URL string might be as follows:
http://+:80/reportserver, provides access to the report server.
http://+:80/reports, provides access to the web portal.
If you are accessing the report server from a remote machine, you want to make sure you have configured any firewall rules if there is a firewall present.
You need to open up the TCP port that you have configured for your Web Service URL and Web Portal URL. By default, these are configured on TCP port 80.
To configure integration with the Power BI service so you can pin report items to a Power BI dashboard, see Integrate with the Power BI service.
To configure the web portal so you can access it on a remote computer to view and manage reports, see Configure a firewall for report server access and Configure a report server for remote administration.
For information on how to install SQL Server 2016 Reporting Services native mode, see Install Reporting Services native mode report server. For information on how to install SQL Server 2016 Reporting Services in SharePoint integration mode, see Install the first Report Server in SharePoint mode.
With your report server installed, begin to create reports and deploy those to your report server. For information on how to start with Report Builder, see Install Report Builder.
To create reports using SQL Server Data Tools, download SQL Server Data Tools.
More questions? Try asking the Reporting Services forum