Created
October 25, 2023 04:21
-
-
Save DocGreenRob/dbb1445a646967b6d69ade3cb5245d76 to your computer and use it in GitHub Desktop.
SSRS 2014 Migration w/ Custom Forms Authentication
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SSRS 2014 Migration w/ Custom Forms Authentication |
CustomSecuritySample
https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample
Infrastructure Overview
- 002 - Vinalla + ExtRSAuth
- 003 - ExtRSAuth
- 004 - Vinalla
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
SSRS Installation Guidance
Installation
SSRS is a stand alone install as of 2017
2022 supports SQL Database Engine 2012 SP4 or later so we can go directly to 2022
Download Microsoft SQL Server 2022 Reporting Services from Official Microsoft Download Center
Licensing
SSRS uses the same licensing as SQL Server. The SQL Server product key will need to be provided for installation on a separate machine.
Find the product key for SQL Server Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn
The licensing level we need for SQL Server to license SSRS may vary from the licensing level we need for the SQL install itself. Note the following features per sku:
Features supported by different editions - SQL Server Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn
We should vet if Web edition is sufficient for our needs or if we need to go to Standard edition
SQL Server 2022—Pricing | Microsoft
System Requirements
2022 supports SQL Database Engine 2012 SP4 or later so we can go directly to 2022
Supported Operating System
Windows Server 2019, Windows Server 2016, Windows 10, Windows 11, Windows Server 2022
You'll need
.NET Framework 4.7 or later
SQL Server Database Engine (2012 SP4 or later), to store the report server database
Machine requirements and licensing follow SQL Server recommendations.
I'd recommend a 2 core 8 GB ec2 instance to start with a dedicated disk for the ssrs installation folder
AWS rds is not a viable option since we need to implement custom authentication
SQL Server 2022: Hardware & software requirements - SQL Server | Microsoft Learn
Note: we’ll need to change the service account for the report server to a credential that is recognized by the database server. Ideally a domain service account
Install SQL Server Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn
Upgrade and Migration Guide
Upgrade and Migrate Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn