I’ve had the most frustrating 4 hours trying to install SQL Server 2008.
It boils down to this: the sql installer has five bugs that stop you installing it properly. Now I’m not sure if most people have seen the SQL Server 2008 installer but it goes on and on checking pre-requisites and performing other tests yet completely and utterly FAILS when trying to do ANY type of install on Windows 2008 Server x64 when you’ve removed SQL Server 2005 beforehand.