none
Unable to install SP2 for SQL 2005 - missing SqlSupport.msi

    Question

  • I have seen a few postings in regards to this so I know it has to be a known problem.  I haven't seen a solid solution posted yet.  Is there an answer to getting this SP2 installed for those of us that are missing the SqlSupport.msi file.  Below is the log from the failed install that details the problem I have.

    === Verbose logging started: 02/26/2007  20:09:34  Build type: SHIP UNICODE 3.01.4000.2435  Calling process: c:\ff90771f64dd6f8ce34ad219f3114010\hotfix.exe ===
    MSI (c) (B4:08) [20:09:34:531]: Resetting cached policy values
    MSI (c) (B4:08) [20:09:34:531]: Machine policy value 'Debug' is 0
    MSI (c) (B4:08) [20:09:34:531]: ******* RunEngine:
               ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
               ******* Action:
               ******* CommandLine: **********
    MSI (c) (B4:08) [20:09:34:531]: Client-side and UI is none or basic: Running entire install on the server.
    MSI (c) (B4:08) [20:09:34:531]: Grabbed execution mutex.
    MSI (c) (B4:08) [20:09:34:546]: Cloaking enabled.
    MSI (c) (B4:08) [20:09:34:546]: Attempting to enable all disabled priveleges before calling Install on Server
    MSI (c) (B4:08) [20:09:34:546]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (C0:94) [20:09:34:562]: Grabbed execution mutex.
    MSI (s) (C0:E0) [20:09:34:562]: Resetting cached policy values
    MSI (s) (C0:E0) [20:09:34:562]: Machine policy value 'Debug' is 0
    MSI (s) (C0:E0) [20:09:34:562]: ******* RunEngine:
               ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
               ******* Action:
               ******* CommandLine: **********
    MSI (s) (C0:E0) [20:09:34:562]: Machine policy value 'DisableUserInstalls' is 0
    MSI (s) (C0:E0) [20:09:34:593]: File will have security applied from OpCode.
    MSI (s) (C0:E0) [20:09:34:656]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi' against software restriction policy
    MSI (s) (C0:E0) [20:09:34:656]: SOFTWARE RESTRICTION POLICY: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi has a digital signature
    MSI (s) (C0:E0) [20:09:35:906]: SOFTWARE RESTRICTION POLICY: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi is permitted to run at the 'unrestricted' authorization level.
    MSI (s) (C0:E0) [20:09:35:906]: End dialog not enabled
    MSI (s) (C0:E0) [20:09:35:906]: Original package ==> C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
    MSI (s) (C0:E0) [20:09:35:906]: Package we're running from ==> C:\WINDOWS\Installer\380cff.msi
    MSI (s) (C0:E0) [20:09:35:906]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
    MSI (s) (C0:E0) [20:09:35:906]: APPCOMPAT: no matching ProductCode found in database.
    MSI (s) (C0:E0) [20:09:35:906]: MSCOREE not loaded loading copy from system32
    MSI (s) (C0:E0) [20:09:35:906]: Couldn't find local patch ''. Looking for it at its source.
    MSI (s) (C0:E0) [20:09:35:906]: Resolving Patch source.
    MSI (s) (C0:E0) [20:09:35:906]: User policy value 'SearchOrder' is 'nmu'
    MSI (s) (C0:E0) [20:09:35:906]: User policy value 'DisableMedia' is 0
    MSI (s) (C0:E0) [20:09:35:906]: Machine policy value 'AllowLockdownMedia' is 0
    MSI (s) (C0:E0) [20:09:35:906]: SOURCEMGMT: Media enabled only if package is safe.
    MSI (s) (C0:E0) [20:09:35:906]: SOURCEMGMT: Looking for sourcelist for product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
    MSI (s) (C0:E0) [20:09:35:906]: Note: 1: 1706 2: {EE92F683-5F5C-4970-BB0B-9AC591B60268} 3: 
    MSI (s) (C0:E0) [20:09:35:906]: SOURCEMGMT: Failed to resolve source
    MSI (s) (C0:E0) [20:09:35:921]: Note: 1: 1708
    MSI (s) (C0:E0) [20:09:35:921]: Note: 1: 2729
    MSI (s) (C0:E0) [20:09:35:921]: Note: 1: 2729
    MSI (s) (C0:E0) [20:09:35:921]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.

    MSI (s) (C0:E0) [20:09:35:937]: MainEngineThread is returning 1612
    The installation source for this product is not available.  Verify that the source exists and that you can access it.
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
    MSI (c) (B4:08) [20:09:36:046]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (B4:08) [20:09:36:046]: MainEngineThread is returning 1612
    === Verbose logging stopped: 02/26/2007  20:09:36 ===

    I look forward to hearing from anyone with a solution.  Thanks.

    Barry

    Wednesday, March 07, 2007 12:37 PM