SQL Server 2005 can be installed on Vista 5728 (Despite the warning indicating it's not compatible), but installing SP1 seems to stop SQL from working. The solution seems to be to remove and then re-install SQL Server 2005.
When is SQL Server 2005 SP2 going to be available? Apparently this will be the version supported on Vista.