SQL 2005 on Windows Server 2022
Background:
This article is written on 29-Jun-2022
Some of us might not be so lucky to get their hands on the latest Microsoft SQL Server and still stuck with an old SQL, like SQL 2005.
Despite various cautions on the web, we have no other choice but to troll through and try to install SQL 2005 even on Windows Server 2022.
There are various references on the web regarding SQL 2005 installation on newer Windows Server versions.
Prerequisites
- Install .net 3.0 (see Appendix A below)
- SQL2k5 Fix files (Fix Error SQL2005.zip)
Program compatibility warning
On running setup, below compatibility prompt may appear several times, you may close or run without help.
Installation
Failure if prerequisite is not installed from Windows Server 2022
If .NET 3.5 (including .NET 2.0) prerequisite, has been installed, installation will start.
- Please note that Reporting Services is greyed out. This is due to IIS version.
Please see my other article for SQL 2005 Reporting Services installation
When installer try to start SQL service, it will fail.
DO NOT PRESS CANCEL
We need to replace two files to allow SQL service to run
Go to folder: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
Rename these two files:
- sqlservr.exe
- sqlos.dll
and copy-paste from the SQL Fix
Press retry and installation is successful
Enjoy your SQL 2005 on Windows Server 2022 !
Appendix A — .NET 3.5 installation (including .NET 2.0)
* .NET 3.5 installation took very long in my case (> 1 hour), please set alternate source path as by default Win22 looks into E:\sources drive. Perhaps your installation disc is on D:\.
If you see the yellow ribbon, check your installation disc disk number. By default somehow Win22 looks into E:\Sources, while your installation disc might be in D:\
