SSRS Install, Setup and Configuration


By:   |   Updated: 2020-12-01   |   Comments (5)   |   Related: > Reporting Services Installation


Problem

SQL Server Reporting Services (SSRS) is another one of the major components of the Microsoft Business Intelligence (MSBI) stack. It's used to generate interactive and automated reports.

The SSRS installation used to be part of the SQL Server installer up through SQL Server 2016. As of SQL Server 2017, the installation has been moved to its own separate downloadable installer. It is still not overly complicated, but it is helpful to know where to get the installer and what to expect before you go through the installation process. This tip will show you how to obtain the installer and walk through the various screens and options that are part of the installation process for SSRS.

Solution

We'll walk through each of the steps of a new installation of SSRS 2019 on Windows Server 2019. 

SSRS Minimum Hardware and Software Requirements

You'll likely have a lot more disk and memory than this, but the bare minimum hardware and software required to install SQL Server 2019 are:

  • Windows Server 2016 or Windows 10 TH1 1507
  • 6 GB of available hard disk space
  • 4 GB memory
  • 1.4 GHz minimum 64-bit CPU

And to install SSRS, you will need an already installed SQL Server.

SSRS 2019 Install

Obtain and Run the SSRS Installer

Download the installer from the Microsoft Download Center here: Microsoft SQL Server 2019 Reporting Services.

Run the SQLServerReportingServices.exe executable when the download is complete, and the first screen will open.

  1. Click on 'Install Reporting Services'
SSRS Install Screen 1

Product Key

Product key id required for a paid edition.

  1. Select 'Enter the product key' radio button and enter your product key
  2. Next
SSRS Install Screen 2

License Terms

You will need to agree to the license terms.

  1. Click 'I accept the license terms' checkbox
  2. Next
SSRS Install Screen 3

Database Server

You will be reminded an installed SQL Server is required to configure the SSRS server and are presented with one option to install Reporting Services.

  1. Next
SSRS Install Screen 4

Install location

This is where you will need to change the SSRS installation directory from the default on the C:\ drive.

  1. Configure SSRS install directory
  2. Install
SSRS Install Screen 5

Configure Server

At this point Reporting Services is installed and it's time to do some basic configuration to it before we can do anything.

  1. 'Configure report server' to open the Configuration Manager
SSRS Install Screen 6

Configuration Manager

Reporting Services Configuration Manager program opens, and we will see the machine name and instance will automatically populate. The first step is to connect to the SSRS server.

  1. Connect
SSRS Install Screen 7

Service Account

Best practice is to not use the default account to run any of the SQL Server services. This discussion is somewhat out of scope for this tip but Microsoft Docs has more information on configuring Windows service accounts for SQL Server here: Configure Windows Service Accounts and Permissions

  1. 'Service Account'
  2. Configure service account
  3. Apply
SSRS Install Screen 8

Report Server Databases

The Report Server Database screen is where we create the databases ReportServer and ReportServerTempDB.

  1. Database
  2. 'Change Database'
SSRS Install Screen 9

SSRS Databases

We are creating a fresh installation of SSRS, so we leave the 'Create a new report server database.' radio button selected. Note: You would just select the 'Choose an existing report server database' button to point Reporting Services to an existing set of databases.

  1. Next
SSRS Install Screen 10

Verify Connectivity to SQL Server

It's a good idea to verify that we can successfully connect to the SQL Server with our credentials here before attempting the database creations.

  1. 'Test connection'
  2. OK
  3. Next
SSRS Install Screen 11

Continue if Test Connection was successful.

  1. Next
SSRS Install Screen 12
  1. Next
SSRS Install Screen 13

Create Databases

We can now verify our information is correct before proceeding with the database creations.

  1. Review Summary
  2. Next
SSRS Install Screen 14

Verify Successful Completion

We want to see that each step was successful.

  1. Verify all steps show Success
  2. Finish
SSRS Install Screen 15

Create URLs

Now that we have our databases created it's time to create the SSRS web service. First, we create the Web Service URL.

  1. 'Web Service URL'
  2. Apply
SSRS Install Screen 16

Next, we create the Web Portal URL.

  1. Web Portal URL
  2. Apply

Then SSRS will restart.

SSRS Install Screen 17

Very URL Creation

Time to verify we can connect to both URLs.

  1. Click 'Web Service URL'
  2. Click on URL
SSRS Install Screen 18

We expect to see the default browser open to Report Server screen.

SSRS Install Screen 19

Now, we'll check the Web Portal URL.

  1. 'Web Portal URL'
  2. Click on URL
SSRS Install Screen 20

We expect to see the default browser open to the Reporting Services Screen.

SSRS Install Screen 21

We now have a fully functional SSRS installation that is ready to deploy reports to. Following are some optional settings we can also configure.

E-mail Settings

If you will have automated report subscriptions going to email, you will need to configure the email settings.

  1. E-mail Settings
  2. Enter 'Sender Address' (This doesn't have to be a valid email address on your mail system but it does have to be in the format [email protected] or the SMTP server will reject it.)
  3. Enter your SMTP server name
  4. You can leave Authentication at 'No authentication' if your SMTP server does not require authentication, or
    1. Expand dropdown and choose 'Username and password (Basic)' to enter SMTP credentials if required
    2. Choose 'Report server service account (NLTM)'  to use service account to authenticate
  5. Apply

Troubleshooting tip: If you experience any problems getting email working, Microsoft Docs has this very handy guide to troubleshooting SMTP issues using Telnet: Use Telnet to Test SMTP Communication on Exchange Servers. Even though it says Exchange, it's applicable to any SMTP server. It's a little awkward to use at first but a great way to very simply verify you can get through a firewall, and test sender address, etc.

SSRS Install Screen 22

Subscription Settings

If you are automating reports to go to a file on a file share you can enter the credentials in the Subscription Settings tab.

  1. Subscription Settings
  2. Check off 'Specify a file share account'
  3. Enter Windows account in the form DOMAIN\account
  4. Enter password
  5. Confirm password
  6. Apply
SSRS Install Screen 23

Close Configuration Manager

  1. Exit
SSRS Install Screen 24
Next Steps


Last Updated: 2020-12-01


get scripts

next tip button



About the author
MSSQLTips author Joe Gavin Joe Gavin is from Greater Boston. He has held many roles in IT and is currently a SQL Server Database Administrator.

View all my tips



Comments For This Article




Friday, March 12, 2021 - 10:23:35 AM - Joe Gavin Back To Top (88385)
I believe you are correct joris. There is no way I know of to have more than 1 instance.

Friday, March 12, 2021 - 3:19:29 AM - joris Back To Top (88384)
Hey,

in sql2016 and older you could define an ssrs instance name. With this new installer this option seems to be gone. Is this correct ?

also since you cannot define an instance name to the ssrs only 1 installation is possible on a server it seems. Am i seeing this correctly ?

Friday, March 12, 2021 - 1:22:52 AM - Hieu Ho Back To Top (88383)
Wonderful!

Wednesday, January 06, 2021 - 7:07:54 AM - Joe Gavin Back To Top (88006)
Thanks Randy. Good idea.

Tuesday, January 05, 2021 - 4:55:14 PM - Randy Knight Back To Top (88005)
Great article but one thing I would add is how to get the product key. In most cases, the product key is baked into the SQL Server ISO and you have to run the first few steps of that installer to get the product key to use for SSRS.


download





Recommended Reading

Adding Reporting Services to an existing SQL Server 2005 installation

How to add Reporting Services to an existing SQL Server Clustered Instance

Install and Configure SQL Server Reporting Services 2012 SP1 and 2014 in SharePoint Integrated Mode Part 1

SQL Server Reporting Services Standalone Installation

Installing SQL Server Reporting Services 2017














get free sql tips
agree to terms