Unable to install Service Pack 1 for SQL Server 2008.
Issue :
The Service Pack 1 installation on SQL Server 2008 fails with the following errors :
detail.txt:
Instance INST01 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): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Start time: 2010-04-21 07:51:29
End time: 2010-04-21 07:52:18
Requested action: Patch
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100421_075033\INST01\SQLSysClrTypes_Cpu64_1.log
Exception help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0
SQLSysClrTypes_Cpu64_1.log:
MSI (s) (E4:84) [07:52:16:388]: Note: 1: 2262 2: Error 3: -2147287038
Action start 7:52:16: CA_ErrorPrereqDotNet20Or30Or35Or40.
MSI (s) (E4:84) [07:52:17:060]: Transforming table Error.
MSI (s) (E4:84) [07:52:17:060]: Transforming table Error.
MSI (s) (E4:84) [07:52:17:060]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (E4:84) [07:52:17:060]: Product: SQL Server System CLR Types -- SQL Server System CLR Types requires the .NET Framework version 2.0 or 3.0 or 3.5 or 4.0. Ensure that this requirement is fulfilled before installing SQL Server System CLR Types.
SQL Server System CLR Types requires the .NET Framework version 2.0 or 3.0 or 3.5 or 4.0. Ensure that this requirement is fulfilled before installing SQL Server System CLR Types.
MSI (s) (E4:84) [07:52:17:060]: Transforming table InstallExecuteSequence.
MSI (s) (E4:84) [07:52:17:060]: Transforming table InstallExecuteSequence.
MSI (s) (E4:84) [07:52:17:060]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 7:52:17: CA_ErrorPrereqDotNet20Or30Or35Or40. Return value 3.
Action ended 7:52:17: INSTALL. Return value 3.
Cause
Setup might have failed to validate the .NET installation though .NET is installed.
Resolution
1. From the above logs we realized that there could be an issue with the .NET installation. Hence, we decided to repair .NET
2. Repair the .NET Framework from Add Remove Program >Highlight .Net Framework 3.5 Sp1 >Select Change >Repair .
3. Run the setup for SP1 again.
Ashutosh Tripathi
SE, Microsoft SQL Server
Reviewed by
Shamik Ghosh, & Rakesh Singh CSS , Microsoft SQL Server
Comments
- Anonymous
February 14, 2013
Nice post