SSRS 2022 Install, Setup and Configuration

By:   |   Updated: 2024-02-21   |   Comments (5)   |   Related: > Reporting Services Installation


Problem

SQL Server Reporting Services (SSRS) is still one of the major components of the Microsoft Business Intelligence (MSBI) stack used to generate interactive and automated reports. It's part of Microsoft SQL Server services, along with SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).

SSRS 2022 includes enhanced Windows Narrator support, security enhancements, browser performance improvements, and accessibility bug fixes.

The SSRS installation process has changed slightly since it was first released in 2004 as an add-on to SQL Server 2000. We saw in a previous tip: SSRS Install, Setup and Configuration, where the SSRS installation used to be part of the SQL Server installer up through SQL Server 2016. As of SQL Server 2017, the installation now has its own downloadable installer. There are only some minor differences between installing SSRS 2019 and SSRS 2022, but knowing where to get the installer and what to expect before you go through the installation process is helpful. This tip will walk through the various screens and options for the installation process.

Solution

We'll look at the minimum hardware and software requirements, see where to get the installer, and walk through each step of installing and configuring a new installation of SSRS 2022. The installation documented here was done on a SQL Server 2022 running on Windows Server 2022.

SSRS 2022 Requirements

You'll likely have more resources than this, but the following are the minimum requirements for installing SSRS 2022:

  • 6 GB of available hard drive space
  • Memory
    • Express Edition
      • 512 MB (1 GB is recommended)
    • All other editions
      • 1 GB (4 GB recommended)
  • CPU
    • X64: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
    • 1.4 GHz (2 GHz recommended)
  • OS
    • Windows Server 2016/2019/2022, Windows 10 / 11
  • SQL Server
    • SQL Server Database Engine 2014 SP3 or later
  • .NET Framework 4.8 or later

SSRS 2022 Installation

Download the Installer

Go to Microsoft SQL Server 2022 Reporting Services Installer Download

  1. Click Download.
Download SSRS 2022

Retrieve and Run Installer

  1. Run SQLServerReportingServices.exe from your Download folder.
Download folder

Welcome Screen

The installer opens, and you're presented with one option on the Welcome screen.

  1. Install Reporting Services.
Welcome Screen

Choose Edition and Install

There are four edition options for SSRS. The first three do not require a Product Key:

  • Evaluation Edition – Full edition that is good for 180 days.
  • Developer Edition – Full edition that can be used for non-production, e.g., test, development, training, or demonstration purposes.
  • Express Edition – Limited edition with fewer features than the full edition.
  • Paid Edition - The fourth option requires a product key. Click Learn more, which will take you to Find the product key for SQL Server Reporting Services.

Install Paid Edition

  1. Click the Enter the product key radio button and enter the key in the box.
  2. Click Next.
Choose Edition

Review Licensing Terms

  1. Read and accept license terms by checking the 'I accept the license terms' checkbox.
  2. Click Next.
License Terms

Install Database Engine

  1. Click Next.
Install SSRS

Specify Install Location

  1. Choose the drive and directory to install SSRS.
  2. Click Install.
Installation Location

The SSRS application has been installed, and now it's time to configure it.

Configure SSRS

  1. Click Configure report server, which runs RSConfigTool.exe to open the Report Server Configuration Manager.
Configure SSRS

Connect to the SSRS Server

  1. Click Connect.
Connect to SSRS

Configure Service Account

If the SSRS server requires access to remote servers, a Windows domain account can be specified to run the SSRS service.

  1. Click on Service Account in the Report Server Configuration Manager.
  2. Select the 'Use another account' radio button. Enter the domain account information and password.
  3. Click Apply.
Configure Service Account

Configure SSRS Databases

Here, we configure the SSRS databases.

  1. Click Database in the Report Server Configuration Manager.
  2. Click Change Database.
Databases

Create New Database

The new SSRS installation can be pointed to an existing set of SSRS databases. However, since this is a new installation, the default 'Create a new report server database' is left selected, and the installer will create the new databases.

  1. Click Next.
Create Databases

Test the Connection

We must test the connection to the SQL Server to ensure connectivity before attempting to create the SSRS databases.

  1. Click Test Connection.
  2. If the connection is successful, click OK.
  3. Click Next.

If the connection is unsuccessful, verify that the SQL Server service is running and accepting connections, and then run the test again.

Test Connection

Name the Database

Unless a name other than the default database names must be used, leave the defaults as ReportServer and ReportServerTemp.

  1. Click Next.
Database Names

Specify Credentials

  1. Click Next.
Credentials

Review Summary

Review the install configuration on the Summary screen.

  1. Click Next if all information is correct.
Summary

Progress and Finish

Verify all tasks completed successfully.

  1. If all tasks are successful, click Finish.
Progress and Finish

At this point, we have the SSRS service installed and databases created.

It's time to create the Web Service and the Web Portal.

Create the SSRS Web Service

  1. Click on Web Service URL.
  2. Click Apply.
Web Service URL

Validate Web Service

Open the Report Server Web Service URL to validate. There are no folders shown because no reports have been deployed yet.

Web Service

Create Web Portal

  1. Click Web Portal URL.
  2. Click Apply.
Web Portal URL

Validate Web Portal

To validate, open the Report Server Web Portal URL. Again, the root folder is empty because no reports have been deployed yet.

Web Portal

We now have a fully functioning SSRS server that's ready for reports to be deployed to it.

Email Settings

If Subscriptions to email reports will be created, we'll need to configure the email settings.

  1. Click E-mail Settings.
  2. Enter a Sender Address in the form of [email protected].
  3. Enter the SMTP Server name.
  4. Select the Authentication dropdown menu to enter the account and password information if your SMTP server requires authentication.
  5. Click Apply.
E-mail Settings

Email has been configured.

  1. Click Exit.
Exit

You may run into failures, sometimes sporadically, related to TLS 1.2, where subscriptions are not sending emails and generating errors like this:

ERROR: Error sending email. Exception: System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Authentication failed because the remote party has closed the transport stream.

Adding the following registry keys will force TLS 1.2:

Windows Registry Editor Version 5.00
 
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319]
"SystemDefaultTlsVersions"=dword:00000001
"SchUseStrongCrypto"=dword:00000001
 
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]
"SystemDefaultTlsVersions"=dword:00000001
"SchUseStrongCrypto"=dword:00000001
Registry Keys to Force TLS 1.2
Next Steps

The following links have more information on SQL Server Reporting Services:



sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip



About the author
MSSQLTips author Joe Gavin Joe Gavin is from the Greater Boston area. He started working with SQL Server and Sybase in 1998 in the financial services industry and has been a SQL Server Database Administrator for a dairy cooperative since 2011. He graduated from Northeastern University in Boston with a Bachelor of Science in Engineering Technology (BSET) degree in Computer Technology. Joe has spoken at the Boston and Providence SQL Saturday events.

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

View all my tips


Article Last Updated: 2024-02-21

Comments For This Article




Tuesday, July 16, 2024 - 12:57:16 PM - Greg Robidoux Back To Top (92396)
Thanks Pavel, It Looks like it is a Microsoft issue.

Tuesday, July 16, 2024 - 12:38:51 PM - Pavel Back To Top (92395)
Hi
link to Microsoft download is broken ?
Pavel

Friday, March 15, 2024 - 1:27:04 PM - Joe Gavin Back To Top (92076)
Robert, that's maybe another tip.

Friday, March 8, 2024 - 1:53:31 AM - Robert de Held Back To Top (92048)
How do you make it high available, load balance and add scale out functionality?

Wednesday, February 21, 2024 - 10:04:56 AM - Michael Back To Top (91998)
This is a well written article. My only critique is that it would be nice to have the current, up-to-date information, on how to make the SSRS HTTPS secure with certificate.














get free sql tips
agree to terms