Re: Cannot Install SQL Server SP2

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_SqlSupport.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\sqlsedll\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@xxxxxxxxxxxxxxxxxx> wrote in message
news:00BA83F5-8C30-4423-9378-CFA5B370F9C6@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OJE%23hY2VHHA.4624@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxx> wrote in message
news:e$406fgVHHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
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\HotFixSqlSupport\Files\.
MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
\\DEVTS320\e$\c4600b83c09df53f898b55c0a3\HotFixSqlSupport\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\HotFixSqlSupport\Files\.
MSI (s) (60:F8) [14:11:45:967]: Note: 1: 2203 2:
\\DEVTS320\e$\cf71b50df7db786fca12dabe1f0c8fb4\HotFixSqlSupport\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







.

Relevant Pages

  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • Re: Any help here???
    ... SQL 200 Server is not local - it's on separate server all by itself. ... trust me - all that's been done here was to install SP2 or upgrade of XP from ... I've completed the install of Visual Studio.NET like I've ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)