none
Sql Server 2005 SP3 Installation RRS feed

  • 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


    Tuesday, January 13, 2009 1:31 PM

Answers


  • 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.
    • Proposed as answer by Prashant Kumar Wednesday, January 14, 2009 6:44 PM
    • Marked as answer by Shwac Friday, January 16, 2009 12:07 AM
    Wednesday, January 14, 2009 12:27 AM

All replies

  • 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
    Tuesday, January 13, 2009 3:48 PM
    Moderator

  • 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.
    • Proposed as answer by Prashant Kumar Wednesday, January 14, 2009 6:44 PM
    • Marked as answer by Shwac Friday, January 16, 2009 12:07 AM
    Wednesday, January 14, 2009 12:27 AM
  • I have full access on both server and UNC share. I try to copy my disk locally, and I have the same error.


    Wednesday, January 14, 2009 2:32 PM
  • 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
    Wednesday, January 14, 2009 2:36 PM
  • 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.
    • Proposed as answer by Prashant Kumar Wednesday, January 14, 2009 6:43 PM
    Wednesday, January 14, 2009 3:20 PM
  • 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.


     

    Wednesday, January 14, 2009 5:58 PM
  • 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.
    Wednesday, January 14, 2009 6:42 PM
  • 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.
    Wednesday, January 14, 2009 7:47 PM
  • 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.
    Wednesday, January 14, 2009 9:51 PM
  • 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
    Thursday, January 15, 2009 5:52 PM
  • 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.
    Thursday, January 15, 2009 9:57 PM
  • 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 ?
    Monday, February 16, 2009 6:32 PM
  • 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 ===

    Monday, February 16, 2009 6:56 PM
  • 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." :(
    Tuesday, May 5, 2009 9:22 AM

  • 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

    Tuesday, April 6, 2010 4:49 PM