I'm trying to install SQL Server SP2 on a SQL Server 2005 Developer Edition.
I'm running SQL Server 2005, SSAS 2005, SSIS 2005, & SSRS 2005 with SP1. (I
have also install VS 2005 Professional on this server.)

I've copied the SP2 exe file on the local C: drive of the SQL 2005 Server
and ran it directly on this server.

The installation error off during the Setup Support Files. I get a window
message that states "The following unexpected error occurred: Unable to
install Windows Installer MSI file".

Here's a copy of the Redist9_Hotfix_KB921869_SQLSupport.msi.log: (Look for
the ==> <== referferences)
================================================
=== Verbose logging started: 2/21/2007 14:11:45 Build type: SHIP UNICODE
3.01.4000.2435 Calling process: c:\5527260625a785ad21475e822652\hotfix.exe
===
MSI (c) (E4:E0) [14:11:45:436]: Resetting cached policy values
MSI (c) (E4:E0) [14:11:45:436]: Machine policy value 'Debug' is 0
MSI (c) (E4:E0) [14:11:45:436]: ******* RunEngine:
******* Product: C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (E4:E0) [14:11:45:436]: Client-side and UI is none or basic: Running
entire install on the server.
MSI (c) (E4:E0) [14:11:45:436]: Grabbed execution mutex.
MSI (c) (E4:E0) [14:11:45:452]: Cloaking enabled.
MSI (c) (E4:E0) [14:11:45:452]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (E4:E0) [14:11:45:452]: Incrementing counter to disable shutdown.
Counter after increment: 0
MSI (s) (60:F4) [14:11:45:467]: Grabbed execution mutex.
MSI (s) (60:F8) [14:11:45:467]: Resetting cached policy values
MSI (s) (60:F8) [14:11:45:467]: Machine policy value 'Debug' is 0
MSI (s) (60:F8) [14:11:45:467]: ******* RunEngine:
******* Product: C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (s) (60:F8) [14:11:45:467]: Machine policy value 'DisableUserInstalls'
is 0
MSI (s) (60:F8) [14:11:45:514]: File will have security applied from OpCode.
MSI (s) (60:F8) [14:11:45:608]: 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) (60:F8) [14:11:45:608]: SOFTWARE RESTRICTION POLICY: C:\Program
Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi has a digital signature
MSI (s) (60:F8) [14:11:45:873]: 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) (60:F8) [14:11:45:873]: End dialog not enabled
MSI (s) (60:F8) [14:11:45:873]: Original package ==> C:\Program
Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
MSI (s) (60:F8) [14:11:45:873]: Package we're running from ==>
C:\WINDOWS\Installer\523c26.msi
MSI (s) (60:F8) [14:11:45:889]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (60:F8) [14:11:45:889]: APPCOMPAT: no matching ProductCode found in
database.
MSI (s) (60:F8) [14:11:45:889]: MSCOREE not loaded loading copy from
system32
MSI (s) (60:F8) [14:11:45:889]: Opening existing patch
'C:\WINDOWS\Installer\2174cb.msp'.
MSI (s) (60:F8) [14:11:45:889]: Note: 1: 2203 2:
C:\WINDOWS\Installer\2174cb.msp 3: -2147287038
MSI (s) (60:F8) [14:11:45:889]: Couldn't find local patch
'C:\WINDOWS\Installer\2174cb.msp'. Looking for it at its source.
MSI (s) (60:F8) [14:11:45:889]: Resolving Patch source.
MSI (s) (60:F8) [14:11:45:889]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (60:F8) [14:11:45:889]: User policy value 'DisableMedia' is 0
MSI (s) (60:F8) [14:11:45:889]: Machine policy value 'AllowLockdownMedia' is
0
MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Media enabled only if package is
safe.
MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Looking for sourcelist for
product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Adding
{EE92F683-5F5C-4970-BB0B-9AC591B60268}; to potential sourcelist list
(pcode;disk;relpath).
MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Now checking product
{EE92F683-5F5C-4970-BB0B-9AC591B60268}
MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Media is enabled for product.
MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Attempting to use LastUsedSource
from source list.
MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Trying source
\\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSql Support\Files\.
MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
\\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSql Support\Files\SqlSupport.m
sp 3: -2147287037
MSI (s) (60:F8) [14:11:45:967]: ==> SOURCEMGMT: Source is invalid due to
missing/inaccessible package. <==
MSI (s) (60:F8) [14:11:45:967]: Note: 1: 1706 2: -2147483647 3:
SqlSupport.msp
MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Processing net source list.
MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Trying source
\\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\Hot FixSqlSupport\Files\.
MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
\\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\Hot FixSqlSupport\Files\SqlSup
port.msp 3: -2147287037
MSI (s) (60:F8) [14:11:45:967]: ==> SOURCEMGMT: Source is invalid due to
missing/inaccessible package. <==
MSI (s) (60:F8) [14:11:45:967]: Note: 1: 1706 2: -2147483647 3:
SqlSupport.msp
MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Processing media source list.
MSI (s) (60:F8) [14:11:47:311]: SOURCEMGMT: Resolved source to:
'SqlSupport.msp'
MSI (s) (60:F8) [14:12:17:655]: Note: 1: 1314 2: SqlSupport.msp
MSI (s) (60:F8) [14:12:17:655]: Unable to create a temp copy of patch
'SqlSupport.msp'.
MSI (s) (60:F8) [14:12:17:702]: Note: 1: 1708
MSI (s) (60:F8) [14:12:17:702]: Note: 1: 2729
MSI (s) (60:F8) [14:12:17:717]: Note: 1: 2729
==> MSI (s) (60:F8) [14:12:17:717]: Product: Microsoft SQL Server Setup
Support Files (English) -- Installation failed. <==

MSI (s) (60:F8) [14:12:17:749]: 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:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
MSI (c) (E4:E0) [14:12:17:889]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (E4:E0) [14:12:17:889]: MainEngineThread is returning 1635
=== Verbose logging stopped: 2/21/2007 14:12:17 ===
================================================== ==========================
=============

I've disable the Virus Software and Disabled the various SQL Server Services
without any success.

Any suggestion on the cause of this error?

Jonathan

I'm getting that same error. Please let me know if you find a solution.

I'm doing a local install (no network drives involved) and even tried
copying the sqlsupport.msi file it's complaining about manually, but to no
avail.

-Ray Rankins



"Jonathan" <jonmau@safeco.com> wrote in message
news:e$406fgVHHA.1208@TK2MSFTNGP03.phx.gbl...
> I'm trying to install SQL Server SP2 on a SQL Server 2005 Developer
> Edition.
> I'm running SQL Server 2005, SSAS 2005, SSIS 2005, & SSRS 2005 with SP1.
> (I
> have also install VS 2005 Professional on this server.)
>
> I've copied the SP2 exe file on the local C: drive of the SQL 2005 Server
> and ran it directly on this server.
>
> The installation error off during the Setup Support Files. I get a window
> message that states "The following unexpected error occurred: Unable to
> install Windows Installer MSI file".
>
> Here's a copy of the Redist9_Hotfix_KB921869_SQLSupport.msi.log: (Look for
> the ==> <== referferences)
> ================================================
> === Verbose logging started: 2/21/2007 14:11:45 Build type: SHIP UNICODE
> 3.01.4000.2435 Calling process:
> c:\5527260625a785ad21475e822652\hotfix.exe
> ===
> MSI (c) (E4:E0) [14:11:45:436]: Resetting cached policy values
> MSI (c) (E4:E0) [14:11:45:436]: Machine policy value 'Debug' is 0
> MSI (c) (E4:E0) [14:11:45:436]: ******* RunEngine:
> ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
> ******* Action:
> ******* CommandLine: **********
> MSI (c) (E4:E0) [14:11:45:436]: Client-side and UI is none or basic:
> Running
> entire install on the server.
> MSI (c) (E4:E0) [14:11:45:436]: Grabbed execution mutex.
> MSI (c) (E4:E0) [14:11:45:452]: Cloaking enabled.
> MSI (c) (E4:E0) [14:11:45:452]: Attempting to enable all disabled
> priveleges
> before calling Install on Server
> MSI (c) (E4:E0) [14:11:45:452]: Incrementing counter to disable shutdown.
> Counter after increment: 0
> MSI (s) (60:F4) [14:11:45:467]: Grabbed execution mutex.
> MSI (s) (60:F8) [14:11:45:467]: Resetting cached policy values
> MSI (s) (60:F8) [14:11:45:467]: Machine policy value 'Debug' is 0
> MSI (s) (60:F8) [14:11:45:467]: ******* RunEngine:
> ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
> ******* Action:
> ******* CommandLine: **********
> MSI (s) (60:F8) [14:11:45:467]: Machine policy value 'DisableUserInstalls'
> is 0
> MSI (s) (60:F8) [14:11:45:514]: File will have security applied from
> OpCode.
> MSI (s) (60:F8) [14:11:45:608]: 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) (60:F8) [14:11:45:608]: SOFTWARE RESTRICTION POLICY: C:\Program
> Files\Microsoft SQL Server\90\Setup
> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi has a digital signature
> MSI (s) (60:F8) [14:11:45:873]: 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) (60:F8) [14:11:45:873]: End dialog not enabled
> MSI (s) (60:F8) [14:11:45:873]: Original package ==> C:\Program
> Files\Microsoft SQL Server\90\Setup
> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
> MSI (s) (60:F8) [14:11:45:873]: Package we're running from ==>
> C:\WINDOWS\Installer\523c26.msi
> MSI (s) (60:F8) [14:11:45:889]: APPCOMPAT: looking for appcompat database
> entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
> MSI (s) (60:F8) [14:11:45:889]: APPCOMPAT: no matching ProductCode found
> in
> database.
> MSI (s) (60:F8) [14:11:45:889]: MSCOREE not loaded loading copy from
> system32
> MSI (s) (60:F8) [14:11:45:889]: Opening existing patch
> 'C:\WINDOWS\Installer\2174cb.msp'.
> MSI (s) (60:F8) [14:11:45:889]: Note: 1: 2203 2:
> C:\WINDOWS\Installer\2174cb.msp 3: -2147287038
> MSI (s) (60:F8) [14:11:45:889]: Couldn't find local patch
> 'C:\WINDOWS\Installer\2174cb.msp'. Looking for it at its source.
> MSI (s) (60:F8) [14:11:45:889]: Resolving Patch source.
> MSI (s) (60:F8) [14:11:45:889]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (60:F8) [14:11:45:889]: User policy value 'DisableMedia' is 0
> MSI (s) (60:F8) [14:11:45:889]: Machine policy value 'AllowLockdownMedia'
> is
> 0
> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Media enabled only if package
> is
> safe.
> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Looking for sourcelist for
> product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Adding
> {EE92F683-5F5C-4970-BB0B-9AC591B60268}; to potential sourcelist list
> (pcode;disk;relpath).
> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Now checking product
> {EE92F683-5F5C-4970-BB0B-9AC591B60268}
> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Media is enabled for product.
> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Attempting to use
> LastUsedSource
> from source list.
> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Trying source
> \\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSql Support\Files\.
> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
> \\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSql Support\Files\SqlSupport.m
> sp 3: -2147287037
> MSI (s) (60:F8) [14:11:45:967]: ==> SOURCEMGMT: Source is invalid due to
> missing/inaccessible package. <==
> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 1706 2: -2147483647 3:
> SqlSupport.msp
> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Processing net source list.
> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Trying source
> \\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\Hot FixSqlSupport\Files\.
> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
> \\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\Hot FixSqlSupport\Files\SqlSup
> port.msp 3: -2147287037
> MSI (s) (60:F8) [14:11:45:967]: ==> SOURCEMGMT: Source is invalid due to
> missing/inaccessible package. <==
> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 1706 2: -2147483647 3:
> SqlSupport.msp
> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Processing media source list.
> MSI (s) (60:F8) [14:11:47:311]: SOURCEMGMT: Resolved source to:
> 'SqlSupport.msp'
> MSI (s) (60:F8) [14:12:17:655]: Note: 1: 1314 2: SqlSupport.msp
> MSI (s) (60:F8) [14:12:17:655]: Unable to create a temp copy of patch
> 'SqlSupport.msp'.
> MSI (s) (60:F8) [14:12:17:702]: Note: 1: 1708
> MSI (s) (60:F8) [14:12:17:702]: Note: 1: 2729
> MSI (s) (60:F8) [14:12:17:717]: Note: 1: 2729
> ==> MSI (s) (60:F8) [14:12:17:717]: Product: Microsoft SQL Server Setup
> Support Files (English) -- Installation failed. <==
>
> MSI (s) (60:F8) [14:12:17:749]: 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:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
> MSI (c) (E4:E0) [14:12:17:889]: Decrementing counter to disable shutdown.
> If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> MSI (c) (E4:E0) [14:12:17:889]: MainEngineThread is returning 1635
> === Verbose logging stopped: 2/21/2007 14:12:17 ===
> ================================================== ==========================
> =============
>
> I've disable the Virus Software and Disabled the various SQL Server
> Services
> without any success.
>
> Any suggestion on the cause of this error?
>
> Jonathan
>
>

If you are running the SQL Server service under a domain login try switching
it to the Local System account. Also look at my later thread about "MSSQL
SP2: Failure: How to Troubleshoot with the Log"

Thanks,

Chuck

"Ray Rankins" <dbadmin@gothamconsulting.com> wrote in message
news:OJE%23hY2VHHA.4624@TK2MSFTNGP03.phx.gbl...
> I'm getting that same error. Please let me know if you find a solution.
>
> I'm doing a local install (no network drives involved) and even tried
> copying the sqlsupport.msi file it's complaining about manually, but to no
> avail.
>
> -Ray Rankins
>
>
>
> "Jonathan" <jonmau@safeco.com> wrote in message
> news:e$406fgVHHA.1208@TK2MSFTNGP03.phx.gbl...
>> I'm trying to install SQL Server SP2 on a SQL Server 2005 Developer
>> Edition.
>> I'm running SQL Server 2005, SSAS 2005, SSIS 2005, & SSRS 2005 with SP1.
>> (I
>> have also install VS 2005 Professional on this server.)
>>
>> I've copied the SP2 exe file on the local C: drive of the SQL 2005 Server
>> and ran it directly on this server.
>>
>> The installation error off during the Setup Support Files. I get a window
>> message that states "The following unexpected error occurred: Unable to
>> install Windows Installer MSI file".
>>
>> Here's a copy of the Redist9_Hotfix_KB921869_SQLSupport.msi.log: (Look
>> for
>> the ==> <== referferences)
>> ================================================
>> === Verbose logging started: 2/21/2007 14:11:45 Build type: SHIP
>> UNICODE
>> 3.01.4000.2435 Calling process:
>> c:\5527260625a785ad21475e822652\hotfix.exe
>> ===
>> MSI (c) (E4:E0) [14:11:45:436]: Resetting cached policy values
>> MSI (c) (E4:E0) [14:11:45:436]: Machine policy value 'Debug' is 0
>> MSI (c) (E4:E0) [14:11:45:436]: ******* RunEngine:
>> ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup
>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
>> ******* Action:
>> ******* CommandLine: **********
>> MSI (c) (E4:E0) [14:11:45:436]: Client-side and UI is none or basic:
>> Running
>> entire install on the server.
>> MSI (c) (E4:E0) [14:11:45:436]: Grabbed execution mutex.
>> MSI (c) (E4:E0) [14:11:45:452]: Cloaking enabled.
>> MSI (c) (E4:E0) [14:11:45:452]: Attempting to enable all disabled
>> priveleges
>> before calling Install on Server
>> MSI (c) (E4:E0) [14:11:45:452]: Incrementing counter to disable shutdown.
>> Counter after increment: 0
>> MSI (s) (60:F4) [14:11:45:467]: Grabbed execution mutex.
>> MSI (s) (60:F8) [14:11:45:467]: Resetting cached policy values
>> MSI (s) (60:F8) [14:11:45:467]: Machine policy value 'Debug' is 0
>> MSI (s) (60:F8) [14:11:45:467]: ******* RunEngine:
>> ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup
>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
>> ******* Action:
>> ******* CommandLine: **********
>> MSI (s) (60:F8) [14:11:45:467]: Machine policy value
>> 'DisableUserInstalls'
>> is 0
>> MSI (s) (60:F8) [14:11:45:514]: File will have security applied from
>> OpCode.
>> MSI (s) (60:F8) [14:11:45:608]: 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) (60:F8) [14:11:45:608]: SOFTWARE RESTRICTION POLICY: C:\Program
>> Files\Microsoft SQL Server\90\Setup
>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi has a digital
>> signature
>> MSI (s) (60:F8) [14:11:45:873]: 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) (60:F8) [14:11:45:873]: End dialog not enabled
>> MSI (s) (60:F8) [14:11:45:873]: Original package ==> C:\Program
>> Files\Microsoft SQL Server\90\Setup
>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
>> MSI (s) (60:F8) [14:11:45:873]: Package we're running from ==>
>> C:\WINDOWS\Installer\523c26.msi
>> MSI (s) (60:F8) [14:11:45:889]: APPCOMPAT: looking for appcompat database
>> entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
>> MSI (s) (60:F8) [14:11:45:889]: APPCOMPAT: no matching ProductCode found
>> in
>> database.
>> MSI (s) (60:F8) [14:11:45:889]: MSCOREE not loaded loading copy from
>> system32
>> MSI (s) (60:F8) [14:11:45:889]: Opening existing patch
>> 'C:\WINDOWS\Installer\2174cb.msp'.
>> MSI (s) (60:F8) [14:11:45:889]: Note: 1: 2203 2:
>> C:\WINDOWS\Installer\2174cb.msp 3: -2147287038
>> MSI (s) (60:F8) [14:11:45:889]: Couldn't find local patch
>> 'C:\WINDOWS\Installer\2174cb.msp'. Looking for it at its source.
>> MSI (s) (60:F8) [14:11:45:889]: Resolving Patch source.
>> MSI (s) (60:F8) [14:11:45:889]: User policy value 'SearchOrder' is 'nmu'
>> MSI (s) (60:F8) [14:11:45:889]: User policy value 'DisableMedia' is 0
>> MSI (s) (60:F8) [14:11:45:889]: Machine policy value 'AllowLockdownMedia'
>> is
>> 0
>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Media enabled only if package
>> is
>> safe.
>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Looking for sourcelist for
>> product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Adding
>> {EE92F683-5F5C-4970-BB0B-9AC591B60268}; to potential sourcelist list
>> (pcode;disk;relpath).
>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Now checking product
>> {EE92F683-5F5C-4970-BB0B-9AC591B60268}
>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Media is enabled for product.
>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Attempting to use
>> LastUsedSource
>> from source list.
>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Trying source
>> \\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSql Support\Files\.
>> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
>> \\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSql Support\Files\SqlSupport.m
>> sp 3: -2147287037
>> MSI (s) (60:F8) [14:11:45:967]: ==> SOURCEMGMT: Source is invalid due to
>> missing/inaccessible package. <==
>> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 1706 2: -2147483647 3:
>> SqlSupport.msp
>> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Processing net source list.
>> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Trying source
>> \\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\Hot FixSqlSupport\Files\.
>> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
>> \\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\Hot FixSqlSupport\Files\SqlSup
>> port.msp 3: -2147287037
>> MSI (s) (60:F8) [14:11:45:967]: ==> SOURCEMGMT: Source is invalid due to
>> missing/inaccessible package. <==
>> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 1706 2: -2147483647 3:
>> SqlSupport.msp
>> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Processing media source list.
>> MSI (s) (60:F8) [14:11:47:311]: SOURCEMGMT: Resolved source to:
>> 'SqlSupport.msp'
>> MSI (s) (60:F8) [14:12:17:655]: Note: 1: 1314 2: SqlSupport.msp
>> MSI (s) (60:F8) [14:12:17:655]: Unable to create a temp copy of patch
>> 'SqlSupport.msp'.
>> MSI (s) (60:F8) [14:12:17:702]: Note: 1: 1708
>> MSI (s) (60:F8) [14:12:17:702]: Note: 1: 2729
>> MSI (s) (60:F8) [14:12:17:717]: Note: 1: 2729
>> ==> MSI (s) (60:F8) [14:12:17:717]: Product: Microsoft SQL Server Setup
>> Support Files (English) -- Installation failed. <==
>>
>> MSI (s) (60:F8) [14:12:17:749]: 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:\Program Files\Microsoft SQL Server\90\Setup
>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
>> MSI (c) (E4:E0) [14:12:17:889]: Decrementing counter to disable shutdown.
>> If
>> counter >= 0, shutdown will be denied. Counter after decrement: -1
>> MSI (c) (E4:E0) [14:12:17:889]: MainEngineThread is returning 1635
>> === Verbose logging stopped: 2/21/2007 14:12:17 ===
>> ================================================== ==========================
>> =============
>>
>> I've disable the Virus Software and Disabled the various SQL Server
>> Services
>> without any success.
>>
>> Any suggestion on the cause of this error?
>>
>> Jonathan
>>
>>
>
>

All my SQL Server services are running under the local account. The install
is being run from c:\temp. All SQL Server services are stopped at the time
of the install.

I have looked at the logs - the install does not get past the first step of
installing the setup support files. The logs indicate that it cannot copy
the C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi file. That file does
exist in the install files as I've found it and attempted to copy it myself.
I've checked the permissions on the C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033 and it's not locked down
in any way.

The messages at the end of the Hotfix.log file are the following:

02/23/2007 11:07:46.750 Installing file: SqlSupport.msi
02/23/2007 11:07:46.921 Copy Engine: Creating MSI install log file at:
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSu pport.msi.log
02/23/2007 11:07:47.015 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer "
02/23/2007 11:07:47.125 Registry: Cannot read registry key value "Debug"
02/23/2007 11:07:48.500 Registry: Opened registry key
"Software\Policies\Microsoft\Windows\Installer "
02/23/2007 11:07:48.531 Registry: Cannot read registry key value "Debug"
02/23/2007 11:07:48.593 Copy Engine: Error, unable to install MSI file:
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
02/23/2007 11:07:48.640 The following exception occurred: Unable to install
Windows Installer MSI file Date: 02/23/2007 11:07:48.640 File:
\depot\sqlvault\stable\setupmainl1\setup\sqlse\sql sedll\copyengine.cpp
Line: 1378
02/23/2007 11:07:55.031 Watson: Param1 = Unknown
02/23/2007 11:07:55.109 Watson: Param2 = 0x64c
02/23/2007 11:07:55.187 Watson: Param3 = Unknown
02/23/2007 11:07:55.250 Watson: Param4 = 0x64c
02/23/2007 11:07:55.265 Watson: Param5 = copyengine.cpp@1378
02/23/2007 11:07:55.296 Watson: Param6 = Unknown
02/23/2007 11:07:55.328 Watson: Param7 = Redist9
02/23/2007 11:07:55.359 Watson: Param8 = @
02/23/2007 11:07:55.390 Watson: Param9 = x86
02/23/2007 11:07:55.421 Watson: Param10 = 3042
02/23/2007 11:07:55.437 Attempting to continue the 32 bit ngen queue
02/23/2007 11:08:05.281 Watson: Param1 = Unknown
02/23/2007 11:08:05.312 Watson: Param2 = 0x643
02/23/2007 11:08:05.343 Watson: Param3 = Unknown
02/23/2007 11:08:05.375 Watson: Param4 = 0x64c
02/23/2007 11:08:05.390 Watson: Param5 = copyengine.cpp@1378
02/23/2007 11:08:05.421 Watson: Param6 = Unknown
02/23/2007 11:08:05.484 Watson: Param7 = Redist9
02/23/2007 11:08:05.562 Watson: Param8 = @
02/23/2007 11:08:05.609 Watson: Param9 = x86
02/23/2007 11:08:05.625 Watson: Param10 = 3042


The messages in the Redist9_Hotfix_KB921896_SqlSupport.msi.log are as
follows:

=== Verbose logging started: 2/23/2007 11:07:47 Build type: SHIP UNICODE
3.01.4000.2435 Calling process:
c:\b60c367ba020164d228c49a6dfbe00\hotfix.exe ===
MSI (c) (3C:7C) [11:07:47:203]: Resetting cached policy values
MSI (c) (3C:7C) [11:07:47:203]: Machine policy value 'Debug' is 0
MSI (c) (3C:7C) [11:07:47:203]: ******* RunEngine:
******* Product: C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (3C:7C) [11:07:47:203]: Client-side and UI is none or basic: Running
entire install on the server.
MSI (c) (3C:7C) [11:07:47:203]: Grabbed execution mutex.
MSI (c) (3C:7C) [11:07:47:218]: Cloaking enabled.
MSI (c) (3C:7C) [11:07:47:218]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (3C:7C) [11:07:47:218]: Incrementing counter to disable shutdown.
Counter after increment: 0
MSI (s) (80:C0) [11:07:47:250]: Grabbed execution mutex.
MSI (s) (80:4C) [11:07:47:250]: Resetting cached policy values
MSI (s) (80:4C) [11:07:47:250]: Machine policy value 'Debug' is 0
MSI (s) (80:4C) [11:07:47:250]: ******* RunEngine:
******* Product: C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (s) (80:4C) [11:07:47:265]: Machine policy value 'DisableUserInstalls'
is 0
MSI (s) (80:4C) [11:07:47:312]: File will have security applied from OpCode.
MSI (s) (80:4C) [11:07:47:375]: 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) (80:4C) [11:07:47:375]: SOFTWARE RESTRICTION POLICY: C:\Program
Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi has a digital signature
MSI (s) (80:4C) [11:07:48:343]: 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) (80:4C) [11:07:48:343]: End dialog not enabled
MSI (s) (80:4C) [11:07:48:343]: Original package ==> C:\Program
Files\Microsoft SQL Server\90\Setup
Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
MSI (s) (80:4C) [11:07:48:343]: Package we're running from ==>
C:\WINDOWS\Installer\6cdc2.msi
MSI (s) (80:4C) [11:07:48:359]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (80:4C) [11:07:48:359]: APPCOMPAT: no matching ProductCode found in
database.
MSI (s) (80:4C) [11:07:48:359]: MSCOREE not loaded loading copy from
system32
MSI (s) (80:4C) [11:07:48:359]: Couldn't find local patch ''. Looking for it
at its source.
MSI (s) (80:4C) [11:07:48:359]: Resolving Patch source.
MSI (s) (80:4C) [11:07:48:359]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (80:4C) [11:07:48:359]: User policy value 'DisableMedia' is 0
MSI (s) (80:4C) [11:07:48:359]: Machine policy value 'AllowLockdownMedia' is
0
MSI (s) (80:4C) [11:07:48:359]: SOURCEMGMT: Media enabled only if package is
safe.
MSI (s) (80:4C) [11:07:48:359]: SOURCEMGMT: Looking for sourcelist for
product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
MSI (s) (80:4C) [11:07:48:359]: Note: 1: 1706 2:
{EE92F683-5F5C-4970-BB0B-9AC591B60268} 3:
MSI (s) (80:4C) [11:07:48:375]: SOURCEMGMT: Failed to resolve source
MSI (s) (80:4C) [11:07:48:375]: Note: 1: 1708
MSI (s) (80:4C) [11:07:48:375]: Note: 1: 2729
MSI (s) (80:4C) [11:07:48:390]: Note: 1: 2729
MSI (s) (80:4C) [11:07:48:390]: Product: Microsoft SQL Server Setup Support
Files (English) -- Installation failed.

MSI (s) (80:4C) [11:07:48:390]: 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) (3C:7C) [11:07:48:484]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (3C:7C) [11:07:48:484]: MainEngineThread is returning 1612
=== Verbose logging stopped: 2/23/2007 11:07:48 ===





"Hawkins, Charles F." <charles.hawkins@NOSPAMjenzabar.net> wrote in message
news:00BA83F5-8C30-4423-9378-CFA5B370F9C6@microsoft.com...
> If you are running the SQL Server service under a domain login try
> switching it to the Local System account. Also look at my later thread
> about "MSSQL SP2: Failure: How to Troubleshoot with the Log"
>
> Thanks,
>
> Chuck
>
> "Ray Rankins" <dbadmin@gothamconsulting.com> wrote in message
> news:OJE%23hY2VHHA.4624@TK2MSFTNGP03.phx.gbl...
>> I'm getting that same error. Please let me know if you find a solution.
>>
>> I'm doing a local install (no network drives involved) and even tried
>> copying the sqlsupport.msi file it's complaining about manually, but to
>> no avail.
>>
>> -Ray Rankins
>>
>>
>>
>> "Jonathan" <jonmau@safeco.com> wrote in message
>> news:e$406fgVHHA.1208@TK2MSFTNGP03.phx.gbl...
>>> I'm trying to install SQL Server SP2 on a SQL Server 2005 Developer
>>> Edition.
>>> I'm running SQL Server 2005, SSAS 2005, SSIS 2005, & SSRS 2005 with SP1.
>>> (I
>>> have also install VS 2005 Professional on this server.)
>>>
>>> I've copied the SP2 exe file on the local C: drive of the SQL 2005
>>> Server
>>> and ran it directly on this server.
>>>
>>> The installation error off during the Setup Support Files. I get a
>>> window
>>> message that states "The following unexpected error occurred: Unable to
>>> install Windows Installer MSI file".
>>>
>>> Here's a copy of the Redist9_Hotfix_KB921869_SQLSupport.msi.log: (Look
>>> for
>>> the ==> <== referferences)
>>> ================================================
>>> === Verbose logging started: 2/21/2007 14:11:45 Build type: SHIP
>>> UNICODE
>>> 3.01.4000.2435 Calling process:
>>> c:\5527260625a785ad21475e822652\hotfix.exe
>>> ===
>>> MSI (c) (E4:E0) [14:11:45:436]: Resetting cached policy values
>>> MSI (c) (E4:E0) [14:11:45:436]: Machine policy value 'Debug' is 0
>>> MSI (c) (E4:E0) [14:11:45:436]: ******* RunEngine:
>>> ******* Product: C:\Program Files\Microsoft SQL
>>> Server\90\Setup
>>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
>>> ******* Action:
>>> ******* CommandLine: **********
>>> MSI (c) (E4:E0) [14:11:45:436]: Client-side and UI is none or basic:
>>> Running
>>> entire install on the server.
>>> MSI (c) (E4:E0) [14:11:45:436]: Grabbed execution mutex.
>>> MSI (c) (E4:E0) [14:11:45:452]: Cloaking enabled.
>>> MSI (c) (E4:E0) [14:11:45:452]: Attempting to enable all disabled
>>> priveleges
>>> before calling Install on Server
>>> MSI (c) (E4:E0) [14:11:45:452]: Incrementing counter to disable
>>> shutdown.
>>> Counter after increment: 0
>>> MSI (s) (60:F4) [14:11:45:467]: Grabbed execution mutex.
>>> MSI (s) (60:F8) [14:11:45:467]: Resetting cached policy values
>>> MSI (s) (60:F8) [14:11:45:467]: Machine policy value 'Debug' is 0
>>> MSI (s) (60:F8) [14:11:45:467]: ******* RunEngine:
>>> ******* Product: C:\Program Files\Microsoft SQL
>>> Server\90\Setup
>>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
>>> ******* Action:
>>> ******* CommandLine: **********
>>> MSI (s) (60:F8) [14:11:45:467]: Machine policy value
>>> 'DisableUserInstalls'
>>> is 0
>>> MSI (s) (60:F8) [14:11:45:514]: File will have security applied from
>>> OpCode.
>>> MSI (s) (60:F8) [14:11:45:608]: 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) (60:F8) [14:11:45:608]: SOFTWARE RESTRICTION POLICY: C:\Program
>>> Files\Microsoft SQL Server\90\Setup
>>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi has a digital
>>> signature
>>> MSI (s) (60:F8) [14:11:45:873]: 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) (60:F8) [14:11:45:873]: End dialog not enabled
>>> MSI (s) (60:F8) [14:11:45:873]: Original package ==> C:\Program
>>> Files\Microsoft SQL Server\90\Setup
>>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
>>> MSI (s) (60:F8) [14:11:45:873]: Package we're running from ==>
>>> C:\WINDOWS\Installer\523c26.msi
>>> MSI (s) (60:F8) [14:11:45:889]: APPCOMPAT: looking for appcompat
>>> database
>>> entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
>>> MSI (s) (60:F8) [14:11:45:889]: APPCOMPAT: no matching ProductCode found
>>> in
>>> database.
>>> MSI (s) (60:F8) [14:11:45:889]: MSCOREE not loaded loading copy from
>>> system32
>>> MSI (s) (60:F8) [14:11:45:889]: Opening existing patch
>>> 'C:\WINDOWS\Installer\2174cb.msp'.
>>> MSI (s) (60:F8) [14:11:45:889]: Note: 1: 2203 2:
>>> C:\WINDOWS\Installer\2174cb.msp 3: -2147287038
>>> MSI (s) (60:F8) [14:11:45:889]: Couldn't find local patch
>>> 'C:\WINDOWS\Installer\2174cb.msp'. Looking for it at its source.
>>> MSI (s) (60:F8) [14:11:45:889]: Resolving Patch source.
>>> MSI (s) (60:F8) [14:11:45:889]: User policy value 'SearchOrder' is 'nmu'
>>> MSI (s) (60:F8) [14:11:45:889]: User policy value 'DisableMedia' is 0
>>> MSI (s) (60:F8) [14:11:45:889]: Machine policy value
>>> 'AllowLockdownMedia' is
>>> 0
>>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Media enabled only if
>>> package is
>>> safe.
>>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Looking for sourcelist for
>>> product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
>>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Adding
>>> {EE92F683-5F5C-4970-BB0B-9AC591B60268}; to potential sourcelist list
>>> (pcode;disk;relpath).
>>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Now checking product
>>> {EE92F683-5F5C-4970-BB0B-9AC591B60268}
>>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Media is enabled for
>>> product.
>>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Attempting to use
>>> LastUsedSource
>>> from source list.
>>> MSI (s) (60:F8) [14:11:45:889]: SOURCEMGMT: Trying source
>>> \\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSql Support\Files\.
>>> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
>>> \\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSql Support\Files\SqlSupport.m
>>> sp 3: -2147287037
>>> MSI (s) (60:F8) [14:11:45:967]: ==> SOURCEMGMT: Source is invalid due to
>>> missing/inaccessible package. <==
>>> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 1706 2: -2147483647 3:
>>> SqlSupport.msp
>>> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Processing net source list.
>>> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Trying source
>>> \\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\Hot FixSqlSupport\Files\.
>>> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
>>> \\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\Hot FixSqlSupport\Files\SqlSup
>>> port.msp 3: -2147287037
>>> MSI (s) (60:F8) [14:11:45:967]: ==> SOURCEMGMT: Source is invalid due to
>>> missing/inaccessible package. <==
>>> MSI (s) (60:F8) [14:11:45:967]: Note: 1: 1706 2: -2147483647 3:
>>> SqlSupport.msp
>>> MSI (s) (60:F8) [14:11:45:967]: SOURCEMGMT: Processing media source
>>> list.
>>> MSI (s) (60:F8) [14:11:47:311]: SOURCEMGMT: Resolved source to:
>>> 'SqlSupport.msp'
>>> MSI (s) (60:F8) [14:12:17:655]: Note: 1: 1314 2: SqlSupport.msp
>>> MSI (s) (60:F8) [14:12:17:655]: Unable to create a temp copy of patch
>>> 'SqlSupport.msp'.
>>> MSI (s) (60:F8) [14:12:17:702]: Note: 1: 1708
>>> MSI (s) (60:F8) [14:12:17:702]: Note: 1: 2729
>>> MSI (s) (60:F8) [14:12:17:717]: Note: 1: 2729
>>> ==> MSI (s) (60:F8) [14:12:17:717]: Product: Microsoft SQL Server Setup
>>> Support Files (English) -- Installation failed. <==
>>>
>>> MSI (s) (60:F8) [14:12:17:749]: 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:\Program Files\Microsoft SQL Server\90\Setup
>>> Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
>>> MSI (c) (E4:E0) [14:12:17:889]: Decrementing counter to disable
>>> shutdown. If
>>> counter >= 0, shutdown will be denied. Counter after decrement: -1
>>> MSI (c) (E4:E0) [14:12:17:889]: MainEngineThread is returning 1635
>>> === Verbose logging stopped: 2/21/2007 14:12:17 ===
>>> ================================================== ==========================
>>> =============
>>>
>>> I've disable the Virus Software and Disabled the various SQL Server
>>> Services
>>> without any success.
>>>
>>> Any suggestion on the cause of this error?
>>>
>>> Jonathan
>>>
>>>
>>
>>
>

Okay - I was finally able to get SP2 installed. Apparently, something was
corrupted with the Windows Installer information for SQL Server 2005 as I
was unable to even uninstall SQL Server 2005 itself via the Add/Remove
programs control panel without getting the "The installation source for this
product is not available. Verify that the source exists and that you can
access it." error. I even tried re-installing SQL SErver 2005 from the
initial setup file, but that was giving me the same error as the SP2 setup
with the inability to install the SQL Server Setup Support files.

I ended up having to get the Windows Installer Cleanup utility
(http://support.microsoft.com/default...b/290301/en-us) to clear out
the install information

I first tried just deleting the SQL Setup Support Files with the installer
cleanup utilty and then reinstalling them with the SQL Server 2005
installer. It was able to successfully re-install the SQL Setup Support
files. Then I ran the SP2 install again and it got past the Setup Suppot
files step, but then it just failed on most of the rest of the components.

I then again tried to reinstall SQL Server 2005 over what was already there,
but that woudlnt' work either as it too was failing to re-install the
installed database components. The only way to get it to work successfully
completely was to run the Windows Installer Cleanup utility and remove all
of the SQL Server 2005 installed components from the Windows INstaller
database. I then reinstalled SQL Server 2005 from the original RTM install
disk and then was able to apply SP2 successfully. On the plus side, all of
my databases were still online and intact after this process (although it's
probably a good idea to back them up or at least copy the mdf files
somewhere safe after SQL Server is shut down).

So, to summarize, if you are having the exact same problem with SP2 being
unable to install the SQL Setup Support Files, the following should fix
things and let you get your SQL SErver instance upgraded to SP2:

1. Download and run the Windows Installer Cleanup Utility and delete the SQL
Setup Support Files and all SQL Server 2005 installed componenents from the
WIndows Installer database

2. Re-install SQL Server 2005 from the initial setup disk

3. Run the SP2 setup utility.



-Ray Rankins