SQL Server 2008 Service Pack 1 installation problem

Question

I am using Windows 7.

Today I saw "Microsoft SQL Server 2008 Service Pack 1 (KB968369)" as an optional update in the updates list. I've tried to intstall it but it failed with Code CF2E222F. I found nothing about this code on the internet.

I've also tried to install the sp manually. I've downloaded it an tried to install. But it also failed.

SQL Server Setup has encountered the following error: C:\Windows\Installer\9bcac.msi.

Any suggestions?

Answer 1

Look at the link How to: View and Read SQL Server Setup Log Files

Copy / paste all errors from folder %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\summary.txt

---

Thanks, Leks

Answer 2

Here's the summary:

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):      -819060177
 Exit facility code:      1838
 Exit error code:        8751
 Exit message:         C:\Windows\Installer\9bcac.msi
 Start time:          2010-04-28 10:10:14
 End time:           2010-04-28 10:11:02
 Requested action:       Patch
 Log with failure:       C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100428_100952\Detail.txt
 Exception help link:      http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.2531.0%26EvtType%3d0x4C9229A1%400x2FCB8C55

Machine Properties:
 Machine name:         MACHINE_NAME
 Machine processor count:    4
 OS version:          Windows Vista
 OS service pack:        
 OS region:           Türkiye
 OS language:          English (United States)
 OS architecture:        x86
 Process architecture:     32 Bit
 OS clustered:         No

Product features discovered:
 Product       Instance       Instance ID          Feature                 Language       Edition       Version     Clustered 
 Sql Server 2008   MSSQLSERVER     MSSQL10.MSSQLSERVER      Database Engine Services         1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008   MSSQLSERVER     MSSQL10.MSSQLSERVER      SQL Server Replication          1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008   MSSQLSERVER     MSSQL10.MSSQLSERVER      Full-Text Search             1033         Developer Edition  10.0.1600.22  No    
 Sql Server 2008   MSSQLSERVER     MSAS10.MSSQLSERVER       Analysis Services            1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008   MSSQLSERVER     MSRS10.MSSQLSERVER       Reporting Services            1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008   RETAILSTORE     MSSQL10.RETAILSTORE      Database Engine Services         1033         Developer Edition  10.0.1600.22  No    
 Sql Server 2008   SQLEXPRESS      MSSQL10.SQLEXPRESS       Database Engine Services         1033         Express Edition   10.1.2531.0   No    
 Sql Server 2008   SQLEXPRESS      MSSQL10.SQLEXPRESS       SQL Server Replication          1033         Express Edition   10.1.2531.0   No    
 Sql Server 2008                             Management Tools - Basic         1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008                             Management Tools - Complete       1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008                             Client Tools Connectivity        1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008                             Client Tools Backwards Compatibility   1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008                             Client Tools SDK             1033         Developer Edition  10.1.2531.0   No    
 Sql Server 2008                             Integration Services           1033         Developer Edition  10.1.2531.0   No    

Package properties:
 Description:          SQL Server Database Services 2008
 SQLProductFamilyCode:     {628F8F38-600E-493D-9946-F4178F20A8A9}
 ProductName:          SQL2008
 Type:             RTM
 Version:            10
 SPLevel:            1
 KBArticle:           KB968369
 KBArticleHyperlink:      http://support.microsoft.com/?kbid=968369
 PatchType:           SP
 AssociateHotfixBuild:     0
 Platform:           x86
 PatchLevel:          10.1.2531.0
 ProductVersion:        10.0.1600.22
 GDRReservedRange:       10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
 PackageName:          SQLServer2008-KB968369-x86.exe
 Installation location:     g:\2aa334eee83bd39b499730\x86\setup\

User Input Settings:
 ACTION:            Patch
 ALLINSTANCES:         False
 CLUSTERPASSIVE:        False
 CONFIGURATIONFILE:       
 HELP:             False
 INDICATEPROGRESS:       False
 INSTANCENAME:         <empty>
 QUIET:             False
 QUIETSIMPLE:          False
 X86:              False

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:        The rule result report file is not available.

Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented

Exception type: System.IO.FileNotFoundException
  Message: 
    C:\Windows\Installer\9bcac.msi
  Data: 
   DisableWatson = true
  Stack: 
    at Microsoft.SqlServer.Chainer.Infrastructure.MsiNativeMethodHelpers.GetDBProperty(ServiceContainer context, String pathToMsi, String propertyName)
    at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.GetMsiRtmVersion(PackageInstallProperty targetPackage)
    at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.IsApplicablePatch(PatchProperty currentPatch, PackageInstallProperty targetPackage)
    at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.ExecuteAction(String actionId)
    at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.GetInstalledPackages(String instanceName, List`1& installedInstancePackages, List`1& installedSharedPackages, String& returnedErrorMessage)
    at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CollectProductData()
    at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase.LoadFeatureTreeDefinitionAllInstances()
    at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase.LoadFeatureTreeDefinition()
    at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase..ctor(ServiceContainer context)
    at Microsoft.SqlServer.Configuration.PatchFeatureTree..ctor(ServiceContainer context)
    at Microsoft.SqlServer.Configuration.PatchFeatureTree.InitializePatchFeatureTree(ServiceContainer context)
    at Microsoft.SqlServer.Configuration.SetupExtension.InitializeUIDataAction.ExecuteAction(String actionId)
    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

Answer 3

I think it is looking for the file C:\Windows\Installer\9bcac.msi which does not exists.

I've searched that file on the internet but no results. I've also looked for it in the sql 2008 disc, but could not find.

Answer 4

Hi,

According to the error message, the SQL Server 2008 SP1 setup can’t find cached MSI file which is for sql_engine_core_inst.msi (sqlrun_sql.msi in SQL Server 2005) the main installation (RTM) of an instance of SQL Server Database Engine. During the installation of SQL Server 2008 RTM, the <SQL Server 2008 Root Folder>\<X86>\Setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi is cached to %windir%\Installer folder for future use such as service pack.

So as to resolve this problem, please copy sql_engine_core_inst.msi from <SQL Server 2008 Root Folder>\<X86>\Setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi to C:\Windows\Installer and rename it to 9bcac.msi. Now, you should be able to install SQL Server 2008 Service Pack.

The following articles talk about the similar setup problems for SQL Server 2005:
http://blogs.msdn.com/sqlserverfaq/archive/2009/01/30/part-1-sql-server-2005-patch-fails-to-install-with-an-error-unable-to-install-windows-installer-msp-file.aspx
http://blogs.msdn.com/sqlserverfaq/archive/2009/02/27/part-2-sql-server-2005-patch-fails-to-install-with-an-error-unable-to-install-windows-installer-msp-file.aspx

Thanks,
Chunsong

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 5

wow that works.

Thank you very much..