I tried again today to install SQL Server 2005 on WHS. All the other components installed except for the actual Server, the Native Client and the Vss Writer ( what ever its actually called). To get this far you need to work around the SSL issue on WHS, which hopefully will be solved by the time it ships.
This KB article helped alot, even though its for SQL 2000.
To install SQL Server 2000 successfully, export the certificates to a file, and then delete the certificates from the Certificate MMC snap-in. After you successfully install SQL Server 2000:
1.Stop the SQL Server service.
2.Reinstall your certificates.
3.Start the SQL Server service.
There’s a KB article on exporting and installing certificates here.
With just a small caveat. WHS will automatically repopulate the Certificates in Personal/Certificates folder. You need to make sure that the imported certificate is the only one in there, which means you delete the new one. if you don’t do this the Remote Website will not work. I’ve no idea why.
So I’m going to hunt for the SQL Install log and see if I can find a workaround for what ever went wrong.
Random Musings 