Sql Server 2005 Installation Issues…

If installation of Sql Server 2005 fails on XP because of MSXML6
Then check the following thread
http://www.windows-tech.info/15/62c4c7d22384e2f6.php

Windows Installer CleanUp Utility
http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml

When you try to install SQL Server 2005 you may get the following error message during setup: “Shared Memory Provider: No process is on the other end of the pipe”
http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/968cd292-5a3f-4c48-9347-4604a6fa9872/
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

…finaly found the problem to be the certificate used.
I noticed that a certificate was added to the machinekeys just recently.
(in C:Documents and SettingsAll UsersApplication
DataMicrosoftCryptoRSAMachineKeys)

I renamed it to another name and re-installed sql server.
I noticed that sql server ERRORLOG complained about certificate that it
couldn’t load and the generation of a self-generaed certificate (see below)

“2005-12-10 21:01:02.30 Server The server could not load the
certificate it needs to initiate an SSL connection. It returned the following
error: 0x8009030d. Check certificates to make sure they are valid.
2005-12-10 21:01:02.49 Server A self-generated certificate was
successfully loaded for encryption.”

Now the installation succeeded

http://groups.google.com/group/microsoft.public.sqlserver.connect/browse_thread/thread/dbec4a9a271f69a6/7cd22694da3a6062?lnk=st&q=%22Shared+Memory+Provider%3A+No+process+is+on+the+other+end+of+the+pipe%22&rnum=2&hl=en#7cd22694da3a6062