none
Unable to Update SQL 2005 and 2008 on SBS 2003

    Question

  • I have inherited a SBS 2003 server at my new job that had many issues. I have finally gotten the server cleaned up for the most part, but I cannot seem to get SQL 2005 SP4 and SQL 2008 SP3 to install. I have followed the KB on restoring missing cache and windows installer files, I have tried to run repairs and everything I try fails . We have several databases in SQL that run our production floor, and I need to resolve these errors. 

    Here is the summary.txt from SQL 2008

    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):           687538905
      Exit facility code:            251
      Exit error code:               729
      Exit message:                  Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "Errors.resources" was correctly embedded or linked into assembly "Microsoft.SqlServer.Discovery" at compile time, or that all the satellite assemblies required are loadable and fully signed.
      Start time:                    2013-03-21 16:47:57
      End time:                      2013-03-21 16:49:14
      Requested action:              Patch
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130321_164734\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.5500.0%26EvtType%3d0x00049E5C%400xE02C8B54

    Machine Properties:
      Machine name:                  SERVER
      Machine processor count:       4
      OS version:                    Windows Server 2003
      OS service pack:               Service Pack 2
      OS region:                     United States
      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 2005      BKUPEXEC             MSSQL.1                        Database Engine Services                 1033                 Express Edition      9.2.3042        No        
      Sql Server 2005      BKUPEXEC             MSSQL.1                        SQL Server Replication                   1033                 Express Edition      9.2.3042        No        
      Sql Server 2005      BKUPEXEC             MSSQL.1                        SharedTools                              1033                 Express Edition      9.2.3042        No        
      Sql Server 2005      MICROSOFT##SSEE      MSSQL.2005                     Database Engine Services                 0                    Windows Internal Database 9.4.5000        No        
      Sql Server 2005      MICROSOFT##SSEE      MSSQL.2005                     SharedTools                              0                    Windows Internal Database 9.4.5000        No        
      Sql Server 2005      SERVER               MSSQL.2                        Database Engine Services                 1033                 Express Edition      9.2.3042        No        
      Sql Server 2005      SERVER               MSSQL.2                        SharedTools                              1033                 Express Edition      9.2.3042        No        
      Sql Server 2005                                                          Tools                                    1033                 Express Edition      9.2.3042        No        
      Sql Server 2005                                                          ToolsClient                              1033                 Express Edition      9.2.3042        No        
      Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Express Edition      9.2.3042        No        
      Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            Database Engine Services                 1033                 Standard Edition     10.1.2531.0     No        
      Sql Server 2008                                                          Management Tools - Basic                 1033                 Standard Edition     10.1.2531.0     No        
      Sql Server 2008                                                          Management Tools - Complete              1033                 Standard Edition     10.1.2531.0     No        
      Sql Server 2008                                                          Client Tools Connectivity                1033                 Standard Edition     10.1.2531.0     No        
      Sql Server 2008                                                          Client Tools Backwards Compatibility     1033                 Standard 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:                       3
      KBArticle:                     KB2546951
      KBArticleHyperlink:            http://support.microsoft.com/?kbid=2546951
      PatchType:                     SP
      AssociatedHotfixBuild:         0
      Platform:                      x86
      PatchLevel:                    10.3.5500.0
      ProductVersion:                10.0.1600.22
      GDRReservedRange:              10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0;10.0.4010.0:10.0.4250.0;10.0.5501.0:10.0.5750.0
      PackageName:                   SQLServer2008-KB2546951-x86.exe
      Installation location:         h:\ab2fde95b442f505933d6135\x86\setup\

    User Input Settings:
      ACTION:                        Patch
      ALLINSTANCES:                  True
      CLUSTERPASSIVE:                False
      CONFIGURATIONFILE:             
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTANCENAME:                  <empty>
      QUIET:                         True
      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.Resources.MissingManifestResourceException
        Message: 
            Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "Errors.resources" was correctly embedded or linked into assembly "Microsoft.SqlServer.Discovery" at compile time, or that all the satellite assemblies required are loadable and fully signed.
        Data: 
          DisableWatson = true
        Stack: 
            at System.Resources.ManifestBasedResourceGroveler.HandleResourceStreamMissing(String fileName)
            at System.Resources.ManifestBasedResourceGroveler.GrovelForResourceSet(CultureInfo culture, Dictionary`2 localResourceSets, Boolean tryParents, Boolean createIfNotExists, StackCrawlMark& stackMark)
            at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo requestedCulture, Boolean createIfNotExists, Boolean tryParents, StackCrawlMark& stackMark)
            at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)
            at System.Resources.ResourceManager.GetObject(String name, CultureInfo culture, Boolean wrapUnmanagedMemStream)
            at System.Resources.ResourceManager.GetObject(String name, CultureInfo culture)
            at Microsoft.SqlServer.Discovery.MsiException.GetErrorMessage(Int32 errorNumber, CultureInfo culture)
            at Microsoft.SqlServer.Discovery.MsiException.GetErrorMessage(MsiRecord errorRecord, CultureInfo culture)
            at Microsoft.SqlServer.Discovery.MsiException.get_Message()
            at System.Exception.ToString(Boolean needFileLineInfo)
            at System.Exception.ToString(Boolean needFileLineInfo)
            at System.Exception.ToString(Boolean needFileLineInfo)
            at System.Exception.ToString()
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
            at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(HandleInternalException exceptionHandler)
            at Microsoft.SqlServer.Chainer.Setup.Setup.RunRequestedWorkflow()
            at Microsoft.SqlServer.Chainer.Setup.Setup.Run()
            at Microsoft.SqlServer.Chainer.Setup.Setup.Start()
            at Microsoft.SqlServer.Chainer.Setup.Setup.Main()

    I beleive that Both 2008 and 2005 are unable to find their proper source code from the installations, unfortunately I have none of the original media that these programs were installed with. I do have the license\product key for SQL 2008, but no where to download that particular version of the product with. Please let me know if there are more log files that are needed to help narrow down this issue. Any help is greatly appreciated.

    jgarciajr75@live.com
    Friday, March 22, 2013 12:40 PM

Answers