Install SQL Server Reporting Services

THIS TOPIC APPLIES TO: yesSQL Server Reporting Services (2017 and later) noPower 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.

Note

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.

Note

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.

  1. Find the location of SQLServerReportingServices.exe and launch the installer.

  2. Select Install Reporting Services.

    Install Reporting Services

  3. Choose an edition to install and then select Next.

    Choose edition

    You can choose either Evaluation or Developer edition from the drop down.

    Evaluation or developer editions

    Otherwise, you can enter a product key.

  4. Read and agree to the license terms and conditions and then select Next.

  5. You need to have a Database Engine available to store the report server database. Select Next to install the report server only.

    Database not required for install

  6. Specify the install location for the report server. Select Install to continue.

    Specify install path

    Note

    The default path is C:\Program Files\Microsoft SQL Server Reporting Services.

  7. After a successful setup, select Configure Report Server to launch the Reporting Services Configuration Manager.

    Configure the report server

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.

Windows Service

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:

Part Description
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 http://<computername>/reportserver, http://localhost/reportserver, or http://<IPAddress>/reportserver.
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.

Firewall

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.

Additional configuration

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.

Next steps

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