SQL Server Reporting Services (SSRS) Versions
Microsoft SQL Server Reporting Services ( SSRS or S.S.R.S. or RS ) is a native server-based reporting platform for creating reports from relational or multidimensional data sources.
A widely used and dynamic tool it provides a comprehensive, server-based reporting solution that allows the authoring, manageability, and delivery of reports in multiple ways and formats, such as on the Web or via e-mail, in Excel, PDF, CSV, XML and Word etc.
SQL Server Reporting Services (SSRS) is a separate install from SQL Server 2017 onwards.
Reporting Services 2022 build numbers:
Reporting services 2019 build numbers:, reporting services 2017 build numbers:, reporting services 2016 build numbers:, reporting services 2014 build numbers:, reporting services 2012 build numbers:.
You can comment here . If you know of a SSRS version that we don't have listed here, please use the comments.
I work on this site continuously and keep the information up to date. If it helps you, you can support me:
Other useful sites › SQL Server Versions List · Firebird Database Versions List · Exchange Server Versions List · SharePoint Servers Version List · Microsoft Knowledge Base Monitoring
SSRS 2022 Install, Setup and Configuration
By: Joe Gavin | Updated: 2024-02-21 | Comments (1) | Related: > Reporting Services Installation
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.
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
- 512 MB (1 GB is recommended)
- 1 GB (4 GB recommended)
- X64: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
- 1.4 GHz (2 GHz recommended)
- Windows Server 2016/2019/2022, Windows 10 / 11
- 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
- Click Download .
Retrieve and Run Installer
- Run SQLServerReportingServices.exe from your Download folder.
The installer opens, and you're presented with one option on the Welcome screen.
- Install Reporting Services.
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
- Click the Enter the product key radio button and enter the key in the box.
- Click Next .
Review Licensing Terms
- Read and accept license terms by checking the 'I accept the license terms' checkbox.
Install Database Engine
Specify Install Location
- Choose the drive and directory to install SSRS.
- Click Install .
The SSRS application has been installed, and now it's time to configure it.
- Click Configure report server , which runs RSConfigTool.exe to open the Report Server Configuration Manager.
Connect to the SSRS Server
- Click Connect .
Configure Service Account
If the SSRS server requires access to remote servers, a Windows domain account can be specified to run the SSRS service.
- Click on Service Account in the Report Server Configuration Manager.
- Select the 'Use another account' radio button. Enter the domain account information and password.
- Click Apply .
Configure SSRS Databases
Here, we configure the SSRS databases.
- Click Database in the Report Server Configuration Manager.
- Click Change Database .
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.
Test the Connection
We must test the connection to the SQL Server to ensure connectivity before attempting to create the SSRS databases.
- Click Test Connection .
- If the connection is successful, click OK .
If the connection is unsuccessful, verify that the SQL Server service is running and accepting connections, and then run the test again.
Name the Database
Unless a name other than the default database names must be used, leave the defaults as ReportServer and ReportServerTemp.
Review the install configuration on the Summary screen.
- Click Next if all information is correct.
Progress and Finish
Verify all tasks completed successfully.
- If all tasks are successful, click 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
- Click on 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.
Create Web Portal
- Click 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.
We now have a fully functioning SSRS server that's ready for reports to be deployed to it.
If Subscriptions to email reports will be created, we'll need to configure the email settings.
- Click E-mail Settings .
- Enter a Sender Address in the form of [email protected] .
- Enter the SMTP Server name.
- Select the Authentication dropdown menu to enter the account and password information if your SMTP server requires authentication.
Email has been configured.
- Click 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:
The following links have more information on SQL Server Reporting Services:
- SSRS Install, Setup and Configuration
- SQL Server Reporting Services 2017 Installation and Configuration
- Install SSRS ReportServer Databases on Azure SQL Managed Instance
- Installing SQL Server Reporting Services 2017
- SQL Server Reporting Services Standalone Installation
- How to Add SSRS to Existing SQL Server Clustered Instance
- PowerShell Commands for SQL Server Reporting Services
- Visual Studio 2019 Install and Configure for the SQL Server DBA
- How to Install and Configure SSRS with Amazon RDS SQL Server
- Side by Side SSRS Install and Upgrade to Minimize Downtime
About the author
Comments For This Article
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
report viewer control version 126.96.36.199 not working with Microsoft Edge
The integrated SSRS report was not shown in Edge, but it did display in IE 11.
I integrated report viewer control (version 188.8.131.52) with my C# application in Visual Studio 2013.
Anyone encountered the same issue?
SQL Server Reporting Services A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. 2,727 questions Sign in to follow
Hi @Ed , Is there any error message when displayed on Edge? Usually the way to resolve this kind of issue is to try to update the report viewer control version to the latest version. Best Regards, Joy
If the answer is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
On-premises reporting with Power BI Report Server
Power BI Report Server is the on-premises solution for reporting today, with the flexibility to move to the cloud tomorrow. It's included with Power BI Premium so you have the ability to move to the cloud on your terms.
Publish Power BI reports on-premises
Report Server gives your users access to rich, interactive reports, and the enterprise reporting capabilities of SQL Server Reporting Services. Explore visual data and quickly discover patterns to make better, faster decisions. At the same time, generate pixel-perfect paginated reports your business needs. You also have the ability to confidently scale to thousands of users because Power BI Report Server is based on a proven, enterprise-grade platform.
On-premises reporting today
Apply governance on your own terms, with Power BI Report Server. Build your BI environment on-premises and distribute reports behind your organization’s firewall.
Cloud-ready for tomorrow
Build on your on-premises reporting infrastructure, knowing it’s part of a comprehensive, cloud-ready solution. Use Power BI Report Server today—an investment that’s compatible with Power BI in the cloud.
Create, publish, and distribute Power BI reports
1. create reports.
Author beautiful reports with Power BI Desktop. Visually explore data with a freeform drag-and-drop canvas and modern data visualizations.
2. Publish to Power BI Report Server
Publish reports directly to Power BI Report Server. Organize your reports in folders, manage access, and update as necessary.
3. Distribute and consume across devices
Share reports for your users to consume on the web and across mobile devices to meet a range of business needs.
Power BI Report Server is part of Power BI Premium
Power BI Premium, with Power BI Report Server, has you covered with a complete solution. Power BI Premium provides dedicated capacity in the cloud and enhanced performance—without requiring per-user licenses for those consuming reports. And, it includes Power BI Report Server for on-premises reporting.
Try Power BI Report Server for free
Okay, let's get your download started!
Let us know where we can send you tips and tricks for getting started fast with Power BI.
- Items of Personal Information to be Collected: First Name, Last Name, Email Address, Phone Number, Company name and size, Job Title, Country/Region of residence, and any other fields visible on this form.
- Purpose of Collection and Use: Microsoft will use the data for the purpose described on this form.
- Retention/Use Period of Personal Information: As long as needed to provide the service(s) you are requesting.
Participation requires transferring your personal data to other countries in which Microsoft operates, including the United States. By submitting this form, you agree to the transfer of your data outside of China. Privacy Statement .
- Contact Sales
- Chat with Sales
Available Monday to Friday
8 AM to 5 PM Central Time.
Request we contact you
Power BI contact sales widget
Chat with a Microsoft sales specialist for answers to your Power BI questions.
Internet Explorer 11 has retired as of 15 June, 2022
Microsoft SQL Server 2022 Reporting Services
SQL Server Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality.
Important! Selecting a language below will dynamically change the complete page content to that language.
- Paginated reports optimized for document generation and printing.
- A modern web portal you can view in any modern web browser.
Supported Operating Systems
Windows Server 2019, Windows Server 2016, Windows 10, Windows 11, Windows Server 2022
- .NET Framework 4.8 or later
- SQL Server Database Engine (2014 SP3 or later), to store the report server database
- Download the Evaluation Edition of Microsoft SQL Server
- Install SQL Server Reporting Services (SQLServerReportingServices.exe)
- Configure your report server using Report Server Configuration Manager
Unofficial. Microsoft. ReportingServices 2019.11.0
- Package Manager
- Script & Interactive
Assemblies for Reporting Services 2019.11 (15). The package contains the following assemblies: Microsoft.ReportingServices.Authorization.dll, Microsoft.ReportingServices.Diagnostics.dll, Microsoft.ReportingServices.Interfaces.dll. This package is built with NuGet Package Explorer by installing Microsoft SQL Server 2019 Reporting Services - November 2019, https://www.microsoft.com/en-us/download/details.aspx?id=100122 , and importing the installed assemblies to the package.
- No dependencies.
This package is not used by any NuGet packages.
This package is not used by any popular GitHub repositories.
Windows Photos gets Generative erase, and recent AI editing features now available on Arm64 devices and Windows 10
- Mala Srivatsa
Hello Windows Insiders,
We’re excited to share with you our latest editing capability available for the Photos app, Generative erase. Plus, all our recently released AI edit features, including Blur background, Remove and replace background, and Generative erase, are also now available in the Photos app for Arm64 devices and Windows 10. This update is beginning to roll out to Windows Insiders in all channels today (including Windows Insiders on Windows 10 in the Release Preview Channel). Make sure to update your app to version number 2024.11020.21001.0 or higher .
Our well-known Spot fix tool has received a boost with the help of AI and is now known as Generative erase in the app. This feature allows you to fix and remove distractions from your photos, like background objects or miscellaneous visual clutter. Compared to Spot fix, Generative erase creates a more seamless and realistic result after objects are erased from the photo, even when erasing large areas.
To use Generative erase, go to Edit Image and select the Erase option. Brush over the objects or areas you want to remove. Adjust the brush size to get the right level of precision you need.
For even finer control or removing multiple objects at once, you can disable Auto Apply to add or remove masks, where each mask represents an area that will be erased.
Other fixes and improvements
- All of the current Photos app AI edit features, including Blur background, Remove and Replace background, and Generative erase are now available in the Photos app for Windows 11 for Arm64 devices.
- For the first time, Windows 10 will be receiving all of the AI editing features that were previously available only on Windows 11, including Blur background, Remove and Replace background, and Generative erase.
- Various stability fixes and improvements.
We appreciate your comments and suggestions, so please share your feedback with us!
FEEDBACK: Please file feedback in Feedback Hub (WIN + F) under Apps > Photos .
Thanks, Mala Srivatsa, Senior Product Manager – Windows Photos
Top Contributors in Windows 11: Ramesh Srinivasan - neilpzz - Kapil Arya MVP - _AW_ - Horace Wiggins ✅
February 14, 2024
Top Contributors in Windows 11:
Ramesh Srinivasan - neilpzz - Kapil Arya MVP - _AW_ - Horace Wiggins ✅
- Search the community and support articles
- Search Community member
Ask a new question
Windows 11 23H2 KB5034765 2024-02 Cumulative update removed all printers.
We pushed out last week the latest Windows 11 2024-02 Cumulative update KB5034765 and users are reporting all added printers are gone. We have had to manaully add printers back.
- Subscribe to RSS feed
Replies (0) , question info.
- Windows update
- Norsk Bokmål