SQL 2005 Reporting Service on Windows Server 2022

Background
This article is written on 29-Jun-2022
Please read my earlier article on installing SQL Server 2005 on Windows Server 2022.
https://sardhianto.medium.com/sql-2005-on-windows-server-2022-55a05637b092
Even after successful installation of SQL Server 2005 on Windows Server 2022, we still have not able to install Reporting Service.
SQL 2k5 SSRS installation involves configuring file server, web server, ASP.NET.
Reference(s):
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/bb839480(v=sql.90)?redirectedfrom=MSDN
https://topic.alibabacloud.com/a/64-bit-aspnet-registered-requires-32-bit-aspnet-to-install-microsoft-reporting_win-server_1_36_20104729.html

Prerequisite
- IIS feature is already installed
- SQL Server 2005 is already installed
- SQL Server 2005 Service Pack 2 installer

Configuring IIS 6.0
Open add roles and features

Add roles and features

Install windows role

Choose your server

• On the Select Server Roles page, click Web Server (IIS). Selecting the Web Server role also selects File Server as role dependency. Click Next.
• In my experience, I have to manually select “File Server” role
• In the Role Services page, keep all the items that are selected by default, and then add the following additional items:
  - In Common HTTP Features, select all the items in this section.
  - In Application Development, select ASP.NET. You will be prompted to enable dependent services. Click OK to add the required role services.
  - In Security, select Windows Authentication.
  - In Management Tools, in IIS 6 Management Capability, select all the items.

Various sub selection will prompt

Installation is successful

Enabling 32 bit application in IIS

Open IIS Manager

Click Application Pools

Set application pool defaults enable 32 bit

Installing SQL Server 2005 SP2

Run hotfix.exe

Selection by default

Need restart after installation

Ready to install

Success and reboot

SP2 installation has finished

Launching user provisioning tool

Add user as SQL Server SysAdmin role

Restart the server to complete reconfiguration

Installing Reporting Service (SSRS)

You can also run setup from SQL 2005 installer, but (assuming) SQL 2005 is already installed, then go to “add or remove program”

Modify existing SQL Server 2005

Click blue link to install new component

Point the setup.exe

Note that ASP.Net version check is green

Reporting Service option is enabled

Selecting instance

Service account selection

SSRS not yet configured

Ready to install

Setup is finished

WAIT, YOU ARE NOT FINISHED YET

Install again all the hotfix that you have (up to SP3), to allow SSRS Configuration

Enjoy your SQL2k5 SSRS !