Installing SQL Server 2000 in Windows 7 is pretty much the same as installing in any version of Windows. I provide the guide here just for clarity and to help newbie.
As you have seen in my previous post at Running SQL Server 2000 in Windows 7, I have successfully installed and run SQL Server 2000 in Windows 7 RTM.
SQL Server 2000 Installation Guide.
Step 1 – You are likely to see Program Compatibility Assistant when you run the setup. Ignore it, just Run the program.
Step 2 – Welcome to the classic installation wizard.
Step 3 – Select where to install the server. Local / Remote ?
In some cases, you probably get the following error message after selecting LOCAL COMPUTER.
A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.
as shown in this screen.
This is a known issue with SQL Server 2000 installation and Microsoft Support has the solution. It will tell you to modify registry setting. You can backup and delete PendingFileRenameOperations as mentioned. If you don’t feel safe, just rename to “xxPendingFileRenameOperations” or anything you like. It will do the trick.
Step 4 – Select Create new instance.
Step 5 – Select Server and Client Tools.
Step 6 – Use default instance name or rename it as you see fit. I would recommend you to rename the instance if you are going to install another version of SQL Server.
Step 7 – Select TYPICAL, MINIMUM, or CUSTOM. If you wish to change the installation folder, you can do it here.
Step 8 – use Local System account for highest security privilege level.
Step 9 – Select MIXED MODE (recommended). This enables SQL Server Authentication mode. Enter password for default sa login.
After installation is complete, you can apply SQL Server 2000 Service Pack 4 as well. Ignore the Program Compatibility Assistant again and run the update.
Wait till wizard appears.
Select your SQL Server 2000 instance name.
Upgrade it! and wait till it completes.
Have fun with your SQL Server 2000.
The only issue that I have right now is I can’t apply the latest security patch for SQL Server 2000 such as:
I keep getting Not enough storage error or just a dumb error “installation did not complete“. It’s really not recommended to run SQL Server 2000 in your production server without these updates.
Not enough storage is available to process this command.
After applying compatibility mode to Windows XP SP2 or SP3.
KB899761(ENU) Setup Error
KB899761(ENU) installation did not complete.