MSSQL2005 SP3 - error 1635 Unable to install Windows Installer MSP file

Question

MSSQL2005 SP3 - error 1635 Unable to install Windows Installer MSP file

linlin-630115

SSC-Addicted

Points: 450
More actions
January 11, 2010 at 9:02 pm

#137202

I got an error 1635 Unable to install Windows Installer MSP file when I try to install SP3 on my database server.
Only Database Service, Reporting Service, Client Components are failed due to this error, the rest (Setup Support Files, Integration Services, SQL Server Native Client, MSXML 6.0 Parser, SQLXML4, Backward Compatibility, Microsoft SQL Server VSS Writer) were successfully upgraded to SP3.
Below I have provided summary.txt from setupBootstrap, and also the sqlrun_sql.msp.log, Any help would be greatly appreciated.
summary:
OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 3
Package Version: 4035
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.3.4035 x86
Database Services (MSSQLSERVER) ENU SP2 2005.090.3042.00 x86 STANDARD
Reporting Services (MSSQLSERVER) ENU SP2 9.00.3042.00 x86 STANDARD
Integration Services ENU SP3 9.00.4035.00 x86 STANDARD
SQL Server Native Client ENU 9.00.4035.00 x86
Client Components ENU SP2 9.2.3042 x86 STANDARD
MSXML 6.0 Parser ENU 6.10.1129.0 x86
SQLXML4 ENU 9.00.4035.00 x86
Backward Compatibility ENU 8.05.2312 x86
Microsoft SQL Server VSS Writer ENU 9.00.4035.00 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 4035
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
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 : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\RS9_Hotfix_KB955706_sqlrun_rs.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 4035
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 4035
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 4035
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2312
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 4035
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1635
==============================================================
sqlrun_sql.msp.log
=== Verbose logging started: 1/10/2010 4:34:48 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: f:\d2d2f91660a7480887a560\hotfix.exe ===
MSI (c) (4C:A4) [04:34:48:668]: Resetting cached policy values
MSI (c) (4C:A4) [04:34:48:668]: Machine policy value 'Debug' is 0
MSI (c) (4C:A4) [04:34:48:668]: ******* RunEngine:
******* Product: {130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}
******* Action:
******* CommandLine: **********
MSI (c) (4C:A4) [04:34:48:668]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (4C:A4) [04:34:48:668]: Grabbed execution mutex.
MSI (c) (4C:A4) [04:34:48:683]: Cloaking enabled.
MSI (c) (4C:A4) [04:34:48:683]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (4C:A4) [04:34:48:683]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (70:BC) [04:34:48:713]: Grabbed execution mutex.
MSI (s) (70:54) [04:34:48:713]: Resetting cached policy values
MSI (s) (70:54) [04:34:48:713]: Machine policy value 'Debug' is 0
MSI (s) (70:54) [04:34:48:713]: ******* RunEngine:
******* Product: {130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}
******* Action:
******* CommandLine: **********
MSI (s) (70:54) [04:34:48:713]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (70:54) [04:34:48:713]: Adding MSIINSTANCEGUID to command line.
MSI (s) (70:54) [04:34:48:804]: End dialog not enabled
MSI (s) (70:54) [04:34:48:819]: Original package ==> C:\WINDOWS\Installer\1298b.msi
MSI (s) (70:54) [04:34:48:819]: Package we're running from ==> C:\WINDOWS\Installer\1298b.msi
MSI (s) (70:54) [04:34:48:895]: APPCOMPAT: looking for appcompat database entry with ProductCode '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}'.
MSI (s) (70:54) [04:34:48:895]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (70:54) [04:34:48:895]: Detected that this product uses a multiple instance transform.
MSI (s) (70:54) [04:34:48:895]: MSCOREE not loaded loading copy from system32
MSI (s) (70:54) [04:34:48:970]: Applying multiple instance transform ':SqlRun01.mst'...
MSI (s) (70:54) [04:34:48:970]: Looking for storage transform: SqlRun01.mst
MSI (s) (70:54) [04:34:48:970]: Validating transform 'SqlRun01.mst' with validation bits 0x809
MSI (s) (70:54) [04:34:48:970]: Transform 'SqlRun01.mst' is valid.
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2205 2: 3: Patch
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary.
MSI (s) (70:54) [04:34:48:970]: TRANSFORM: Applying regular transform to database.
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _Validation 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: RegLocator 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: AppSearch 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: CompLocator 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Registry 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: CreateFolder 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Icon 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: InstallUISequence 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: AdminUISequence 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: ReserveCost 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: TypeLib 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Feature 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: MsiAssembly 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (70:54) [04:34:48:970]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ServiceControl 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ModuleDependency 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ModuleSignature 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ModuleComponents 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ServiceInstall 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlGroup 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlConfig 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlScript 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ActionText 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlSku 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlStart 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: Dialog 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlCollation 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlProducts 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: FeatureComponents 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: Control 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ControlEvent 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ControlCondition 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ListView 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: CheckBox 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: EventMapping 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: RadioButton 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: Upgrade 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: TextStyle 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: UIText 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: Shortcut 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: RemoveFile 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: Environment 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Opening existing patch 'C:\WINDOWS\Installer\23b7b031.msp'.
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2203 2: C:\WINDOWS\Installer\23b7b031.msp 3: -2147287038
MSI (s) (70:54) [04:34:48:986]: Couldn't find local patch 'C:\WINDOWS\Installer\23b7b031.msp'. Looking for it at its source.
MSI (s) (70:54) [04:34:48:986]: Resolving Patch source.
MSI (s) (70:54) [04:34:48:986]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (70:54) [04:34:48:986]: User policy value 'DisableMedia' is 0
MSI (s) (70:54) [04:34:48:986]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Looking for sourcelist for product {4A35EF4A-D868-4B15-A84D-3E8925AA9558}
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Adding {4A35EF4A-D868-4B15-A84D-3E8925AA9558}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Now checking product {4A35EF4A-D868-4B15-A84D-3E8925AA9558}
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Media is enabled for product.
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Trying source f:\ce72e419489dc4f16eb9d608259022\HotFixSQL\Files\.
MSI (s) (70:54) [04:34:48:986]: Note: 1: 2203 2: f:\ce72e419489dc4f16eb9d608259022\HotFixSQL\Files\sqlrun_sql.msp 3: -2147287037
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (70:54) [04:34:48:986]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Processing net source list.
MSI (s) (70:54) [04:34:48:986]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp
MSI (s) (70:54) [04:34:48:986]: SOURCEMGMT: Processing media source list.
MSI (s) (70:54) [04:34:49:983]: SOURCEMGMT: Resolved source to: 'sqlrun_sql.msp'
MSI (s) (70:54) [04:35:19:415]: Note: 1: 1314 2: sqlrun_sql.msp
MSI (s) (70:54) [04:35:19:415]: Unable to create a temp copy of patch 'sqlrun_sql.msp'.
MSI (s) (70:54) [04:35:19:415]: Note: 1: 1708
MSI (s) (70:54) [04:35:19:430]: Note: 1: 2729
MSI (s) (70:54) [04:35:19:627]: Note: 1: 2729
MSI (s) (70:54) [04:35:19:627]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (70:54) [04:35:19:657]: MainEngineThread is returning 1635
This patch package could not be opened. Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package.
C:\WINDOWS\Installer\1298b.msi
MSI (c) (4C:A4) [04:35:19:657]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (4C:A4) [04:35:19:657]: MainEngineThread is returning 1635
=== Verbose logging stopped: 1/10/2010 4:35:19 ===

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

brian_winzeler Mr or Mrs. 500 Points: 564 More actions · Answer 1

You're in luck. I just had to deal withi this exact same problem over the last few days. The primary culprit is you are missing some files from your C:\Windows\Installer directory. Everytime you install SQL Server or one of the service packs/hotfixes it will place a copy of the .msi/.msp with a randomly generated name into the Installer directory. If for any reason these files get deleted you won't be able to uninstall or upgrade the missing components without first replacing the files.

This link will get you started: http://blogs.msdn.com/sqlserverfaq/archive/2009/01/30/part-1-sql-server-2005-patch-fails-to-install-with-an-error-unable-to-install-windows-installer-msp-file.aspx

A quick addendum to this though: Service Pack 3 follows a specific order as to what files it needs to know about to install. If you're sitting at 2005 SP2 Update 3282 it's going to want the files for the main install, Cumulative update 3282, and then 2005 SP2. The easiest way to find this information is to go into the registry to this spot -> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\.

You'll have to comb through the stuff here until you find the pieces you need. In each entry there should be the Installer directory filename of the msi or msp you need to replace. This also contains a folder called Patches which will list the ID of each update you've performed on your server. You can go up one level in the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Patches\, and match up this ID and it will tell you the name of the .msp that you need to replace. You can obtain the .msp patch files by using Winzip to extract them from the SP2 and 3282 .exe files.

Hope this helps.

linlin-630115 SSC-Addicted Points: 450 More actions · Answer 2

Thanks so much

one more that I'm worried about

MSI (s) (70:54) [04:34:48:713]: Machine policy value 'DisableUserInstalls' is 0

MSI (s) (70:54) [04:34:48:713]: Adding MSIINSTANCEGUID to command line.

MSI (s) (70:54) [04:34:48:804]: End dialog not enabled

MSI (s) (70:54) [04:34:48:819]: Original package ==> C:\WINDOWS\Installer\1298b.msi

MSI (s) (70:54) [04:34:48:819]: Package we're running from ==> C:\WINDOWS\Installer\1298b.msi

MSI (s) (70:54) [04:34:48:895]: APPCOMPAT: looking for appcompat database entry with ProductCode '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}'.

MSI (s) (70:54) [04:34:48:895]: APPCOMPAT: no matching ProductCode found in database.

MSI (s) (70:54) [04:34:48:895]: Detected that this product uses a multiple instance transform.

MSI (s) (70:54) [04:34:48:895]: MSCOREE not loaded loading copy from system32

MSI (s) (70:54) [04:34:48:970]: Applying multiple instance transform ':SqlRun01.mst'...

MSI (s) (70:54) [04:34:48:970]: Looking for storage transform: SqlRun01.mst

MSI (s) (70:54) [04:34:48:970]: Validating transform 'SqlRun01.mst' with validation bits 0x809

MSI (s) (70:54) [04:34:48:970]: Transform 'SqlRun01.mst' is valid.

'no matching ProductCode found in database' is this an error also?

worrying that I have other errors except the missing msp file ..