Sql Server 2005 SP3 Installation

Question

Hi,
 
I try to install SP3 on SQL Server 2005 Standard SP2 installation (Windows Server 2003 R2), using SQLServer2005SP3-KB955706-x86-ENU.exe locally on the server, with administrator right. Setup always fail on installation of each component, with these messages in event viewer:

Product: Microsoft SQL Server Native Client -- Error 1714. The older version of Microsoft SQL Server Native Client cannot be removed. Contact your technical support group. System Error 1612.

Product: Microsoft SQL Server 2005 Backward compatibility -- Error 1714. The older version of Microsoft SQL Server 2005 Backward compatibility cannot be removed. Contact your technical support group. System Error 1612.

...
...
...

I got this message for each componant to upgrade.

Log result:

=== Verbose logging started: 1/12/2009  14:02:55  Build type: SHIP UNICODE 3.01.4000.4042  Calling process: C:\WINDOWS\system32\msiexec.exe ===
MSI (c) (D0:DC) [14:02:55:593]: Resetting cached policy values
MSI (c) (D0:DC) [14:02:55:593]: Machine policy value 'Debug' is 0
MSI (c) (D0:DC) [14:02:55:593]: ******* RunEngine:
           ******* Product: {130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}
           ******* Action:
           ******* CommandLine: **********
MSI (c) (D0:DC) [14:02:55:593]: Machine policy value 'DisableUserInstalls' is 0
MSI (c) (D0:DC) [14:02:55:609]: Adding MSIINSTANCEGUID to command line.
MSI (c) (D0:DC) [14:02:55:609]: Warning: Local cached package 'C:\WINDOWS\Installer\c20712fa.msi' is missing.
MSI (c) (D0:DC) [14:02:55:609]: User policy value 'SearchOrder' is 'nmu'
MSI (c) (D0:DC) [14:02:55:609]: User policy value 'DisableMedia' is 0
MSI (c) (D0:DC) [14:02:55:609]: Machine policy value 'AllowLockdownMedia' is 0
MSI (c) (D0:DC) [14:02:55:609]: SOURCEMGMT: Media enabled only if package is safe.
MSI (c) (D0:DC) [14:02:55:609]: SOURCEMGMT: Looking for sourcelist for product {130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}
MSI (c) (D0:DC) [14:02:55:609]: SOURCEMGMT: Adding {130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}; to potential sourcelist list (pcode;disk;relpath).
MSI (c) (D0:DC) [14:02:55:609]: SOURCEMGMT: Now checking product {130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}
MSI (c) (D0:DC) [14:02:55:609]: SOURCEMGMT: Media is enabled for product.
MSI (c) (D0:DC) [14:02:55:609]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (c) (D0:DC) [14:02:55:609]: SOURCEMGMT: Trying source \\library\dvd$\Servers\Setup\.
MSI (c) (D0:DC) [14:02:55:843]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (c) (D0:DC) [14:02:55:890]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (D0:DC) [14:02:55:922]: Cloaking enabled.
MSI (c) (D0:DC) [14:02:55:922]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (D0:DC) [14:02:55:984]: SOURCEMGMT: Resolved source to: '\\library\dvd$\Servers\Setup\'
MSI (c) (D0:DC) [14:03:08:167]: SOFTWARE RESTRICTION POLICY: Verifying package --> '\\library\dvd$\Servers\Setup\SqlRun_SQL.msi' against software restriction policy
MSI (c) (D0:DC) [14:03:08:167]: SOFTWARE RESTRICTION POLICY: \\library\dvd$\Servers\Setup\SqlRun_SQL.msi has a digital signature
MSI (c) (D0:DC) [14:03:22:429]: SOFTWARE RESTRICTION POLICY: \\library\dvd$\Servers\Setup\SqlRun_SQL.msi is permitted to run at the 'unrestricted' authorization level.
MSI (c) (D0:DC) [14:03:22:445]: Cloaking enabled.
MSI (c) (D0:DC) [14:03:22:445]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (D0:DC) [14:03:22:445]: End dialog not enabled
MSI (c) (D0:DC) [14:03:22:445]: Original package ==> \\library\dvd$\Servers\Setup\SqlRun_SQL.msi
MSI (c) (D0:DC) [14:03:22:445]: Package we're running from ==> C:\DOCUME~1\Administrator\LOCALS~1\Temp\1\458aac.msi
MSI (c) (D0:DC) [14:03:22:523]: APPCOMPAT: looking for appcompat database entry with ProductCode '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}'.
MSI (c) (D0:DC) [14:03:22:523]: APPCOMPAT: no matching ProductCode found in database.
MSI (c) (D0:DC) [14:03:22:523]: Detected that this product uses a multiple instance transform.
MSI (c) (D0:DC) [14:03:22:523]: MSCOREE not loaded loading copy from system32
MSI (c) (D0:DC) [14:03:22:523]: Applying multiple instance transform ':SqlRun01.mst'...
MSI (c) (D0:DC) [14:03:22:523]: Looking for storage transform: SqlRun01.mst
MSI (c) (D0:DC) [14:03:22:523]: Validating transform 'SqlRun01.mst' with validation bits 0x809
MSI (c) (D0:DC) [14:03:22:523]: Transform 'SqlRun01.mst' is valid.
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2205 2:  3: Patch
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2205 2:  3: PatchPackage
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: Media 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: File 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: TRANSFORM: 'PatchPackage' table is missing or empty.  No pre-transform fixup necessary.
MSI (c) (D0:DC) [14:03:22:523]: TRANSFORM: Applying regular transform to database.
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: _Validation 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: File 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: RegLocator 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: AppSearch 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: CompLocator 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: Registry 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: CreateFolder 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: Icon 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: InstallUISequence 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: AdminUISequence 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038
MSI (c) (D0:DC) [14:03:22:523]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ReserveCost 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: TypeLib 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Feature 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: MsiAssembly 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Class 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ServiceControl 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ModuleDependency 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ModuleSignature 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ModuleComponents 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ServiceInstall 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlGroup 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlConfig 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlScript 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ActionText 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlSku 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlStart 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Dialog 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Error 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlCollation 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlProducts 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: FeatureComponents 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Control 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ControlEvent 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ControlCondition 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ListView 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: CheckBox 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: EventMapping 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: RadioButton 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Upgrade 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: TextStyle 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: UIText 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Media 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Shortcut 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: RemoveFile 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: Environment 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Opening existing patch 'C:\WINDOWS\Installer\c25a6684.msp'.
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2203 2: C:\WINDOWS\Installer\c25a6684.msp 3: -2147287038
MSI (c) (D0:DC) [14:03:22:539]: Couldn't find local patch 'C:\WINDOWS\Installer\c25a6684.msp'. Looking for it at its source.
MSI (c) (D0:DC) [14:03:22:539]: Resolving Patch source.
MSI (c) (D0:DC) [14:03:22:539]: User policy value 'SearchOrder' is 'nmu'
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Media enabled only if package is safe.
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Looking for sourcelist for product {4A35EF4A-D868-4B15-A84D-3E8925AA9558}
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Adding {4A35EF4A-D868-4B15-A84D-3E8925AA9558}; to potential sourcelist list (pcode;disk;relpath).
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Now checking product {4A35EF4A-D868-4B15-A84D-3E8925AA9558}
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Media is enabled for product.
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Trying source e:\5ceda92e9aad1c33009034aa2e\HotFixSQL\Files\.
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 2203 2: e:\5ceda92e9aad1c33009034aa2e\HotFixSQL\Files\sqlrun_sql.msp 3: -2147287037
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Processing net source list.
MSI (c) (D0:DC) [14:03:22:539]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp
MSI (c) (D0:DC) [14:03:22:539]: SOURCEMGMT: Processing media source list.
MSI (c) (D0:DC) [14:03:23:571]: SOURCEMGMT: Resolved source to: 'sqlrun_sql.msp'
MSI (c) (D0:DC) [14:03:53:785]: Note: 1: 1314 2: sqlrun_sql.msp
MSI (c) (D0:DC) [14:03:53:785]: Unable to create a temp copy of patch 'sqlrun_sql.msp'.
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.
\\library\dvd$\Servers\Setup\SqlRun_SQL.msi
MSI (c) (D0:DC) [14:03:53:785]: Note: 1: 1708
MSI (c) (D0:DC) [14:03:53:785]: Note: 1: 2729
MSI (c) (D0:DC) [14:03:53:785]: Note: 1: 2729
MSI (c) (D0:DC) [14:03:53:785]: Product: Microsoft SQL Server 2005 -- Installation failed.

MSI (c) (D0:DC) [14:03:53:832]: MainEngineThread is returning 1635
=== Verbose logging stopped: 1/12/2009  14:03:53 ===

Help will be appreciated
thanks

Answer 1

Hi Shwac,

Can you try copying the disk down to your local machine?  It looks like you're installing it from a UNC share, and I suspect that your Windows account doesn't have sufficient permissions on the network share.

Let us know how you fare!

---

Aaron Alton | thehobt.blogspot.com

Answer 2

Hi Shwac,

I read your log file. All you need to perform is two steps as below :

1.  From the Main setup (RTM version) of SQL Server , copy ...\Servers\Setup\SqlRun_SQL.msi and paste in C:\Windows\Installer. Rename it to c20712fa.msi

2.  Extract SP2 on local disk say at C:\SQLSP2 , copy C:\SQLSP2\HotfixSQL\Files\sqlrun_sql.msp and paste it into C:\Windows\Installer. Rename it to c25a6684.msp


HTH

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 3

I have full access on both server and UNC share. I try to copy my disk locally, and I have the same error.

Answer 4

Hi,

I can try this but... SQLServer2005SP3-KB955706-x86-ENU.exe (downloaded from microsoft web site) is not compressed file and installation start immediatly, I cannot extract anything from this file... How can I do this ?

thanks

Answer 5

Shwac said:

Hi,

I can try this but... SQLServer2005SP3-KB955706-x86-ENU.exe (downloaded from microsoft web site) is not compressed file and installation start immediatly, I cannot extract anything from this file... How can I do this ?

thanks

Shwac,

Plese note I said to extract SP2 ; not SP3 because msp file of SP2 is missing.

Go to command prompt and locate the exe of SP2 (can be downloaded here) and extract using with "/x" or "/extract" something like below:

C:\SQLServer2005SP2-KB921896-x86-ENU.exe /x

Extract it to a folder say C:\SQLSP2 and do as I stated in previous post.

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 6

Hi !

Ok it's working, setup install more components and fail on these components: "Client Component" and "Integrations services"

I can see these messages in summary.txt (I don't have the same verbose log like precedent message):

Product                   : Integration Services
Product Version (Previous): 3042
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB955706_sqlrun_dts.msp.log
Error Number              : 1635
Error Description         : Unable to install Windows Installer MSP file

Product                   : Client Components
Product Version (Previous): 3042
Product Version (Final)   :
Status                    : Failure

Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log

Error Number              : 1635
Error Description         : Unable to install Windows Installer MSP file

do I have to rename these files also ?

When I will install the service pack on other servers, are the files will be renamed as well?

Thanks a lot.

 

Answer 7

Hi Shwac,

That's great news. Well, as far as SSIS and Tools are concerned, if you post the verbose log for both then only I will be able to comment.

You should have the log files for above two as :

1.  C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB955706_sqlrun_dts.msp.log
2.  C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log

On other servers , you don't need to paste/rename the files unless you hit the same error.

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 8

Hi,

I found information to rename msi and msp files in the verbose log...
I will try to install and let you know if it works.

Is this a known installation bug ? It's not a good idea to cancel and retry setup on a production server to rename installation files...

thanks a lot for your help.

Answer 9

Shwac,

That's not a bug. The reason you hit this error is because cached msp/msi files are missing from %windir%\Installer.

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 10

Hi,

It's working, thanks a lot for you help

Probably that all the files in this directory (\Windows\Installer) have been deleted, so files for SP2 were missing.

Shwac

Answer 11

Great. Enjoy! and please mark the solution as answered which helped you.

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 12

Prashant Jha said:

Hi Shwac,

I read your log file. All you need to perform is two steps as below :

1.  From the Main setup (RTM version) of SQL Server , copy ...\Servers\Setup\SqlRun_SQL.msi and paste in C:\Windows\Installer. Rename it to c20712fa.msi

2.  Extract SP2 on local disk say at C:\SQLSP2 , copy C:\SQLSP2\HotfixSQL\Files\sqlrun_sql.msp and paste it into C:\Windows\Installer. Rename it to c25a6684.msp


HTH

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Guys.
I'd read all information here but something is not clear for me.
Prashant Jha said: From the Main setup (RTM version) of SQL Server , copy ...\Servers\Setup\SqlRun_SQL.msi and paste in C:\Windows\Installer. Rename it to c20712fa.msi

How can I find RTM verssion of SQL2005SP3 ? all I have is SQLServer2005SP3-KB955706-x86-ENU.exe from Microsoft but after extract all I can find is SqlRun_SQL.msp not MSI.
Can somebody explain from what location I can get SqlRun_SQL.msi file ?

Answer 13

My error is little a bit different...

Property(S): SQL200532Hotfix4035 = c:\f89681219d2ad6c047\HotFixSQL\Files\sqlrun_sql.msp
MSI (s) (40:AC) [12:58:47:087]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 3 for SQL Server Database Services 2005 ENU (KB955706)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log.

MSI (s) (40:AC) [12:58:47:087]: Note: 1: 1729
MSI (s) (40:AC) [12:58:47:087]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:087]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:150]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:150]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:150]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:150]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:150]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:150]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:150]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:150]: Product: Microsoft SQL Server 2005 -- Configuration failed.

MSI (s) (40:AC) [12:58:47:165]: Attempting to delete file c:\WINDOWS\Installer\2fce8c1d.msp
MSI (s) (40:AC) [12:58:47:165]: Unable to delete the file. LastError = 32
MSI (s) (40:AC) [12:58:47:212]: Cleaning up uninstalled install packages, if any exist
MSI (s) (40:AC) [12:58:47:212]: MainEngineThread is returning 1603
MSI (s) (40:74) [12:58:47:212]: Destroying RemoteAPI object.
MSI (s) (40:00) [12:58:47:228]: Custom Action Manager thread ending.
=== Logging stopped: 2/15/2009  12:58:47 ===
MSI (c) (EC:68) [12:58:47:384]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (EC:68) [12:58:47:384]: MainEngineThread is returning 1603
=== Verbose logging stopped: 2/15/2009  12:58:47 ===

Answer 14

My error is little a bit different...

Property(S): SQL200532Hotfix4035 = c:\f89681219d2ad6c047\HotFixSQL\Files\sqlrun_sql.msp
MSI (s) (40:AC) [12:58:47:087]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 3 for SQL Server Database Services 2005 ENU (KB955706)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log.

MSI (s) (40:AC) [12:58:47:087]: Note: 1: 1729
MSI (s) (40:AC) [12:58:47:087]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:087]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:119]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:119]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:150]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:150]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:150]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:150]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:150]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:150]: Transforming table Error.

MSI (s) (40:AC) [12:58:47:150]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (40:AC) [12:58:47:150]: Product: Microsoft SQL Server 2005 -- Configuration failed.

MSI (s) (40:AC) [12:58:47:165]: Attempting to delete file c:\WINDOWS\Installer\2fce8c1d.msp
MSI (s) (40:AC) [12:58:47:165]: Unable to delete the file. LastError = 32
MSI (s) (40:AC) [12:58:47:212]: Cleaning up uninstalled install packages, if any exist
MSI (s) (40:AC) [12:58:47:212]: MainEngineThread is returning 1603
MSI (s) (40:74) [12:58:47:212]: Destroying RemoteAPI object.
MSI (s) (40:00) [12:58:47:228]: Custom Action Manager thread ending.
=== Logging stopped: 2/15/2009  12:58:47 ===
MSI (c) (EC:68) [12:58:47:384]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (EC:68) [12:58:47:384]: MainEngineThread is returning 1603
=== Verbose logging stopped: 2/15/2009  12:58:47 ===

Have the same issue "Service Pack 3 for SQL Server Database Services 2005 ENU (KB955706)' could not be installed. Error code 1603." :(

Answer 15

Hi Shwac,

I read your log file. All you need to perform is two steps as below :

1.  From the Main setup (RTM version) of SQL Server , copy ...\Servers\Setup\SqlRun_SQL.msi and paste in C:\Windows\Installer. Rename it to c20712fa.msi

2.  Extract SP2 on local disk say at C:\SQLSP2 , copy C:\SQLSP2\HotfixSQL\Files\sqlrun_sql.msp and paste it into C:\Windows\Installer. Rename it to c25a6684.msp


HTH

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Prashant, your solution provided to extract "sqlrun_sql.msp" worked great. However, the file I need and cannot locate is the "SqlRun_SQL.msi" - where/how can I get this file? My problem is similar that Windows Installer cannot locate that particular file.

Thank you,

Van