September 21, 2011 at 12:44 pm
I’m having trouble installing SQL Server 2005 service pack 4 because of missing installer files and missing msp files. To remediate I have been using the instructions from “How to Resolve missing MSI or MSP packages during SQL Server Service Packs, Hotfix or Cumulative Updates” http://support.microsoft.com/kb/2015100 .
When I generate the %computername%_sql_install_details.txt I find a number of missing msp files, such as in this entry:
Patch Key under:
HKEY_CLASSES_ROOT\Installer\Patches\457CACBF7A0F1174EBDD4E45A391E0E1
DisplayName = Hotfix 3159 for SQL Server Tools and Workstation Components 2005 ENU (KB934459)
The both Last Used Source should have same values:
Last Used Source = n;1;e:\ff7e4913557596aed9f3c59363c6502a\HotFixTools\Files\
Last Used Source = n;1;e:\ff7e4913557596aed9f3c59363c6502a\HotFixTools\Files\
Install Date = 20070926
Installer Cache File Path = C:\WINDOWS\Installer\7731c.msp
Package does not exist in the Installer cache.
So I obtain the executable for KB934459 and extract it using the CMD window:
F:\>SQLServer2005-KB934459-x86-ENU.exe /x
A dialog appears allowing me to extract the files to e:\ff7e4913557596aed9f3c59363c6502a and then reports success.
Then in a new CMD window I use the repair source script with a disappointing result:
C:\>Cscript repairsource_v3.js e:\ff7e4913557596aed9f3c59363c6502a\HotFixTools\Files\
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
Found patch located at: E:\ff7e4913557596aed9f3c59363c6502a\hotfixtools\files\sqlrun_tools.msp
Attempting to repair the local cache for PatchCode "{FBCAC754-F0A7-4711-BEDD-E4543A190E1E}"
No action can be taken as the patch has not been applied on the local machine.
In case I was interpreting the path too literally I tried cutting off the subdirectories and running the command again. But the result was similar:
C:\>Cscript repairsource_v3.js e:\ff7e4913557596aed9f3c59363c6502a
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
Found patch located at: E:\ff7e4913557596aed9f3c59363c6502a\hotfixas\files\sqlrun_as.msp
Attempting to repair the local cache for PatchCode "{EF401B99-B07C-4B0C-BAB7-A2364FF3E283}"
No action can be taken as the patch has not been applied on the local machine.
Found patch located at: E:\ff7e4913557596aed9f3c59363c6502a\hotfixdts\files\sqlrun_dts.msp
Attempting to repair the local cache for PatchCode "{CFA092FC-EE04-4860-B5D9-94AE1CFDAD46}"
No action can be taken as the patch has not been applied on the local machine.
Found patch located at: E:\ff7e4913557596aed9f3c59363c6502a\hotfixns\files\sqlrun_ns.msp
Attempting to repair the local cache for PatchCode "{A064C1FC-C039-4EED-9128-91F97CA8DAF7}"
No action can be taken as the patch has not been applied on the local machine.
Found patch located at: E:\ff7e4913557596aed9f3c59363c6502a\hotfixrs\files\sqlrun_rs.msp
Attempting to repair the local cache for PatchCode "{28D5E24A-EB56-4A26-9696-866270361FCC}"
No action can be taken as the patch has not been applied on the local machine.
Found patch located at: E:\ff7e4913557596aed9f3c59363c6502a\hotfixsql\files\sqlrun_sql.msp
Attempting to repair the local cache for PatchCode "{0F910CD4-15C5-46C1-A990-CA2910C8E371}"
No action can be taken as the patch has not been applied on the local machine.
Found patch located at: E:\ff7e4913557596aed9f3c59363c6502a\hotfixtools\files\sqlrun_tools.msp
Attempting to repair the local cache for PatchCode "{FBCAC754-F0A7-4711-BEDD-E4543A190E1E}"
No action can be taken as the patch has not been applied on the local machine.
This repeats for every single msp file reported missing in %computername%_sql_install_details.txt.
However the message is obviously false. Had the patch never been applied on the local machine
there would be no issue with missing an msp file created when the patch was installed on the local
machine.
Is there anything else that I can do to recreate these files?
Thanks!
September 23, 2011 at 5:05 pm
I reviewed several articles on replacing the msp files. For what ever reason I was not able to get instructions from the previous one to produce results. However the script in getcodeinfo.bat from "SQL Server Setup prompts with “The installed product does not match the installation source(s).” (Part I)" was helpful in identifying the missing files and the appropriate cached names quickly.
None of the other process that I used, including the instructions for searching the registry, were quite as helpful.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply