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:           http://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 (1)