Unable to install Service Pack 1 for SQL Server 2008.

  • Article

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