Install SQL Server Reporting Services

  • Article
  • 4 minutes to read

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.

Before you lot 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 straightforward. In that location are only a few steps to install the files.

Note

You exercise not need a SQL Server Database Engine server available at the time of install. You will need ane to configure Reporting Services later on install.

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

  2. Select Install Reporting Services.

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

    For a free edition, choose either Evaluation or Developer from the drop down.

    Evaluation or developer editions

    Otherwise, enter a product key. Find the production cardinal for SQL Server Reporting Services.

  4. Read and hold to the license terms and atmospheric condition then select Next.

  5. Yous need to have a Database Engine available to shop the written report server database. Select Side by side to install the report server just.

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

    Annotation

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

  7. Later on a successful setup, select Configure Written report Server to launch the Study Server Configuration Managing director.

Configure your report server

After you select Configure Report Server in the setup, yous will exist presented with Report Server Configuration Manager. For more than information, see Report Server Configuration Manager.

You demand to create a report server database to consummate the initial configuration of Reporting Services. A SQL Server Database server is required to consummate this stride.

Creating a database on a different server

If y'all are creating the report server database on a database server on a unlike motorcar, yous need to change the service account for the study server to a credential that is recognized on the database server.

Past default, the report server uses the virtual service account. If y'all try to create a database on a different server, you may receive the following fault on the Applying connection rights step.

Organisation.Data.SqlClient.SqlException (0x80131904): Windows NT user or group '(null)' not found. Check the proper noun once more.

To work around the error, you tin can alter the service account to either Network Service or a domain account. Changing the service business relationship to Network Service applies rights in the context of the machine account for the written report server.

For more data, encounter Configure the written report server service account.

Windows Service

A Windows service is created as role 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:

Office Description
Prefix The default prefix is HTTP. If you lot previously installed a Send Layer Security (TLS), previously known every bit Secure Sockets Layer (SSL), certificate, Setup tries to create URL reservations that use the HTTPS prefix.
Host name The default host name is a potent wildcard (+). It specifies that the report server accepts whatever HTTP request on the designated port for any host proper noun that resolves to the computer, including https://<computername>/reportserver, https://localhost/reportserver, or https://<IPAddress>/reportserver.
Port The default port is 80. If you use any port other than port eighty, you lot have to explicitly add together it to the URL when you open spider 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 Study Server Web service, the default virtual directory is reportserver. For the web portal, the default virtual directory is reports.

An case of the complete URL string might exist as follows:

  • https://+:eighty/reportserver, provides access to the report server.

  • https://+:eighty/reports, provides access to the web portal.

Firewall

If you lot are accessing the report server from a remote automobile, yous desire to brand sure yous accept configured any firewall rules if there is a firewall present.

Y'all need to open up the TCP port that you have configured for your Spider web Service URL and Web Portal URL. By default, these are configured on TCP port 80.

Additional configuration

  • To configure integration with the Power BI service and so you lot can pivot report items to a Power BI dashboard, run into Integrate with the Ability BI service.

  • To configure email for subscriptions processing, see E-Mail settings and E-mail delivery in a report server.

  • To configure the web portal and so you can access it on a remote calculator to view and manage reports, see Configure a firewall for written report server access and Configure a study server for remote assistants.

For information on how to install SQL Server Reporting Services native way, see Install Reporting Services native mode report server.

Adjacent steps

With your report server installed, begin to create reports and deploy those to your report server. For information on how to offset with Report Builder, see Install Study Builder.

To create reports using SQL Server Data Tools, download SQL Server Data Tools.

More questions? Try asking the Reporting Services forum