The registry fix worked for me.
I installed SQL 7.0 MSDE on top of a working SQL Server 2005 adn the 2005 was clobbered. I tried re-installing SQL 2005 as a named instance and got the symptoms described at the start of the thread.
Re-installed after applying the registry fix and it worked.
Thanks Byron.