Trying to upgrade 2008R2 to SP3 on a Windows 7 machine
passes all the preflight checks and starts the install, then fails with 'update operation complete with failures'
Can anyone help?
The summary log says
Instance ACT7 overall summary:
Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068024447
Exit facility code: 1212
Exit error code: 29569
Exit message: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Start time: 2015-07-13 15:25:40
End time: 2015-07-13 15:26:11
Requested action: Patch
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20150713_152431\ACT7\sql_engine_core_inst_Cpu64_1.log
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.6000.34
Interesting bits in the sql_engine_core_inst_Cpu64_1.log (can't find how to attach the file sorry)
MSI (s) (24:E4) [15:26:09:466]: Doing action: FindRelatedProducts
Action ended 15:26:09: Do_LogInstallStart_64. Return value 1.
MSI (s) (24:E4) [15:26:09:466]: Skipping FindRelatedProducts action: not run in maintenance mode
Action start 15:26:09: FindRelatedProducts.
MSI (s) (24:E4) [15:26:09:466]: Doing action: AppSearch
Action ended 15:26:09: FindRelatedProducts. Return value 0.
Action start 15:26:09: AppSearch.
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1325 2: v2.0.50727
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1325 2: EventLogMessages.dll
MSI (s) (24:E4) [15:26:09:466]: PROPERTY CHANGE: Adding ASPNET_EVENTLOGDLL property. Its value is 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\EventLogMessages.dll'.
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\\Setup 3: 2
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{FBD367D1-642F-47CF-B79B-9BE48FB34007} 3: 2
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE32\SOFTWARE\Microsoft\VisualStudio\9.0 3: 2
MSI (s) (24:E4) [15:26:09:466]: Note: 1: 1325 2: SQLServer2008R2
MSI (s) (24:E4) [15:26:09:466]: PROPERTY CHANGE: Adding SQLSETUPARPWRAPPER property. Its value is 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\SetupARP.exe'.
MSI (s) (24:E4) [15:26:09:466]: Doing action: RestoreSetupParams_64
Action ended 15:26:09: AppSearch. Return value 1.
MSI (s) (24:E4) [15:26:09:481]: Note: 1: 2235 2: 3: ExtendedType 4: SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM `CustomAction` WHERE `Action` = 'RestoreSetupParams_64'
MSI (s) (24:B0) [15:26:09:481]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI65EF.tmp, Entrypoint: RestoreSetupParams
Action start 15:26:09: RestoreSetupParams_64.
<Func Name='LaunchFunction'>
Function=RestoreSetupParams
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: RestoreSetupParams
PerfTime Start: RestoreSetupParams : Mon Jul 13 15:26:09 2015
<Func Name='RestoreSetupParams'>
Error Code: 0x80077381 (29569)
Windows Error Text: Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Wed Mar 31 02:36:24 2010
Function Name: RestoreSetupParams
Source Line Number: 190
Error Code: 29569
MSI (s) (24!A0) [15:26:10:745]: Product: SQL Server 2008 R2 SP2 Database Engine Services -- Error 29569. SQL Server Setup failed to restore the instance id.
Error 29569. SQL Server Setup failed to restore the instance id.
<Failure Type='Fatal' Error='29569'>
<EndFunc Name='LaunchFunction' Return='29569' GetLastError='203'>
CustomAction RestoreSetupParams_64 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 15:26:10: RestoreSetupParams_64. Return value 3.
Action ended 15:26:10: INSTALL. Return value 3.
Property(S): Installed = 00:00:00