Installing SQL Server Express 2005 on Windows 2008 SBS

Due to what frankly seems to be a complete botch from Microsoft SQL Server Express 2005 can be a pain to get installed on Windows Server 2008 SBS.

See:
http://technet.microsoft.com/en-us/library/cc794697.aspx

Especially:

Installing SQL Server 2005
If you plan to install SQL Server 2005 on the original server running Windows SBS 2008, do the following before you run the installation.

• Click Start, click All Programs, click Accessories, and then click Run.


• Type regedit, and then click OK.


• At the User Account Control prompt, click OK.


• Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90.


• Double-click OriginalMachineName, and then change the OriginalMachineName value name to the current server name.


• Click OK.