SQL Server - Unable to install SQL server 2005 SP3

Hi Reena,
Thanks for the resolution. The issue is resolved.
However, I am now unable to upgrade the SQL server 2005 SP3. When i try to upgrade the SP3, during the install i get the message :-
"The feature you are trying to use is on a network resource that is
unavailable"
It asks for SQLRun_sql.msi and by default the path specified in windows installer is C:\Temp\SQL2005STD\CD1\ which is not present any more.
I uploaded the files on the server, and gave the path C:\Program Files\Microsoft SQL Server\90\Tools\Binn\, but the install failed soon after with the error :- KB 955706 failed.

I checked the log files and following are some of the important observations :

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\HotFix.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.xml

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\HotFix.log----log files reveal the following :-

09/22/2011 01:06:03.915 Installing file: sqlrun_sql.msp
09/22/2011 01:06:03.931 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap

\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
09/22/2011 01:06:03.931 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
09/22/2011 01:06:03.947 Registry: Cannot read registry key value "Debug", error 0
09/22/2011 02:39:10.659 MSP returned 1635: This patch package could not be opened. Verify that the patch package exists and is

accessible, or contact the application vendor to verify that this is a valid Windows Installer patch package.
09/22/2011 02:39:10.674 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
09/22/2011 02:39:10.690 Registry: Cannot read registry key value "Debug", error 0
09/22/2011 02:39:10.690 Copy Engine: Error, unable to install MSP file: g:\9a95c158d77876e3610261\HotFixSQL\Files\sqlrun_sql.msp
09/22/2011 02:39:10.706 The following exception occurred: Unable to install Windows Installer MSP file  Date: 09/22/2011

02:39:10.706  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 807
09/22/2011 02:39:15.081 Watson: Param1 = Unknown
09/22/2011 02:39:15.096 Watson: Param2 = 0x663
09/22/2011 02:39:15.112 Watson: Param3 = Unknown
09/22/2011 02:39:15.112 Watson: Param4 = 0x663
09/22/2011 02:39:15.127 Watson: Param5 = copyengine.cpp@807
09/22/2011 02:39:15.143 Watson: Param6 = Unknown
09/22/2011 02:39:15.159 Watson: Param7 = SQL9
09/22/2011 02:39:15.190 Watson: Param8 = Hotfix@
09/22/2011 02:39:15.206 Watson: Param9 = x86
09/22/2011 02:39:15.206 Watson: Param10 = 4035
09/22/2011 02:39:15.206 Installed product: SQL9
09/22/2011 02:39:15.221 Installing product: Redist9
09/22/2011 02:39:15.237 Installing instance: SQL Server Native Client
09/22/2011 02:39:15.237 Installing target: A4HS-HMO
09/22/2011 02:39:15.252 Installing file: sqlncli.msi
09/22/2011 02:39:15.377 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap

\LOG\Hotfix\Redist9_Hotfix_KB955706_sqlncli.msi.log
09/22/2011 02:39:15.377 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
09/22/2011 02:39:15.377 Registry: Cannot read registry key value "Debug", error 2

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Summary.txt---log files reveal the following :-

----------------------------------------------------------------------------------
Product           : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final)   :
Status            : Failure
Log File          : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number        : 1635
Error Description     : *** Shared String ID 1635 Not Found ***
----------------------------------------------------------------------------------

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log----log files reveal

the following :--

1) Warning: Local cached package 'C:\WINDOWS\Installer\1a0b0c.msi' is missing.

2) MSI (s) (B4:FC) [02:38:39:424]: Package we're running from ==> C:\WINDOWS\Installer\357f75e7.msi

3) Opening existing patch 'c:\WINDOWS\Installer\1a0c00.msp'.
MSI (s) (B4:FC) [02:38:39:518]: Note: 1: 2203 2: c:\WINDOWS\Installer\1a0c00.msp 3: -2147287038
MSI (s) (B4:FC) [02:38:39:518]: Couldn't find local patch 'c:\WINDOWS\Installer\1a0c00.msp'. Looking for it at its source.

I checked for the missing msp file, it was 1a0c00.msp. i checked its corresponding GUID in the registry and with the help of the GUID,i found that KB articel which was needed: :- http://support.microsoft.com/kb/933097
I tried to install it, but it failed with the error message :- A recently applied KB articel failed to install.
Please help.

it seems cached msp for SP2 is missing.

1. Download SQL Server 2005 SP2 (ignore if already downlaoded) and extract* it at a folder say D:\SQLSP2
2. Now copy the file D:\SQLSP2\hotfixsql\files\sqlrun_sql.msp and paste it at C:\WIndowsInstaller.
3. Next,rename file sqlrun_sql.msp at C:\Windows\Installer to 1a1cfb.msp .
4. Start installation of whichever hotfix/Cumulative Update you want to install. It should succeed.

or
15b2af.msp is missing from the Installer folder i.e. C:\WINDOWS\Installer\ , if so you need  to copy sqlrun_dts.msp from extracted folder of SP2 i.e. ...\hotfixdts\files\sqlrun_dts.msp and paste it to C:\Windows\Installer . Further rename this file to 15b2af.msp . Now you can try installing the hotfix

I would like to thank you Anup. Your suggestion worked perfectly in this case. I followed the steps mentioned and SQL server 2005 SP3 was installed successfully. What i did is just a bit different than what you suggested, but the overall idea was same.
1) I checked the log files of the sercvies which failed to install, ie. Database services, Integration sercvices, Client Components etc ,and noted  the corresponding msp and msi files which were missing and the source where the installer was looking to copy the  msi files from.
2) I then copied the msi files from the source and pasted in C:\Windows\Installer\ and renamed it in accordance with missing msi files mentioned in the logs
3) I also downloaded SQL server SP2 and extracted the files in C:\SP2 folder, copied the corresponding missing msp files, pasted it in C:\windows\Instsaller\ and renamed it in accordance with missing msi files mentioned in the logs.
4) I ran the install which went successfully.
Please add any information which might be useful. Your post was excellent in resolving the issue.
Thanks once again.

Nice to hear your problem solved, thanks for posting the suggestion, it will be helpful for other members