January 20, 2010 at 1:53 pm
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.
January 20, 2010 at 7:09 pm
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 ..
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply