SQL Server 2008 R2 SP2 Install Error - Make sure "Errors.Resources" was correctly embedded.......

Answered SQL Server 2008 R2 SP2 Install Error - Make sure "Errors.Resources" was correctly embedded.......

  • Wednesday, January 09, 2013 12:53 PM
     
     

    Hey all,

    My system: Windows 7 x64 with two SQL Server 2008 R2 instances (developer editions).  I'm trying to upgrade to SP2 and get the following error almost immediately on starting the SP2 installation:

    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.

    I've search the internet and not found much to go on.  Any ideas. 

    Thanks in advance,

    Greg

All Replies

  • Wednesday, January 09, 2013 1:37 PM
    Moderator
     
     

    Hello,

    I have never seen this error, but I would try to repair both SQL Server instances, and then apply SP2.

    http://msdn.microsoft.com/en-us/library/cc646006(SQL.105).aspx

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Wednesday, January 09, 2013 2:43 PM
     
     

    No joy there.  Repaired them both and am still getting the error.  I get the same error if I try to apply sp1, too.

    Greg

  • Wednesday, January 09, 2013 2:46 PM
     
     

    I don't know if the stack trace will help, but here it is:

    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.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)
            at System.Resources.ResourceManager.GetObject(String name, CultureInfo culture, Boolean wrapUnmanagedMemStream)
            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()
            at System.Exception.ToString()
            at System.Exception.ToString()
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
            at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, 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()

  • Thursday, January 10, 2013 10:16 AM
    Moderator
     
     

    Hi Greg,

    Please refer to the following blog which about the same issue.

    http://www.woodler.eu/en/april-2012/71-issues-with-service-pack-.html

    If the issue is presists, please post the Setup log file for more information.

    Regards,

    Fanny Liu


    Fanny Liu
    TechNet Community Support

    • Marked As Answer by Greg Wilkerson Friday, January 11, 2013 5:17 PM
    • Unmarked As Answer by Greg Wilkerson Friday, January 11, 2013 5:27 PM
    •  
  • Friday, January 11, 2013 2:02 AM
    Moderator
     
     

    What is the Language of OS and Installed SQL Server instance ?

    Are you sure that you have downloaded the correct service pack package that matches architecture and language?


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

  • Friday, January 11, 2013 5:33 PM
     
     

    Hey Fanny,

    I found this article and had been through it once.  But, just for grins, I went through it again.  The patch file name in my case is sql_as_loc.msp.  The patch code is 5568883F-09B9-435B-BF64-C43CFA1FDE37.  That GUID does not exist in the registry key

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products

    I look for the same GUID on another workstation where a successful upgrade took place and did not find that GUID in the registry either.  So, this doesn't appear to address my issue.

    By setup log, are you referring to the details.txt file in the setup boostrap\log driectory.  Pasting it here isn't going to work.  How do I best post this?

    Greg

  • Friday, January 11, 2013 5:34 PM
     
     

    Ahmen,

    It's the English 64 bit sp and I'm running the English 64 bit db server.  We're good there.

    Greg

  • Tuesday, January 15, 2013 1:09 AM
    Moderator
     
     
    Would you please share upload complete log files to file sharing service like SkyDrive.com

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

  • Tuesday, January 15, 2013 1:30 AM
     
     

    please check if there are any missing MSI/MSP files missing in the installer cache and recache them if missing

    http://support.microsoft.com/kb/969052

  • Thursday, January 17, 2013 9:24 PM
     
     
  • Thursday, January 17, 2013 9:27 PM
     
     

    Hey all,

    Sorry for the delays.  I've been travelling.

    Interesting tool.  The output is below.  Most of these files are referencing volumes I'm going to call transient (USB/SD/Mounted ISO/Temporary folders).  Not sure what to make of that.  For the first run, I had nothing mounted.  After looking at the output, mounted the SQL Server ISO and re-ran.  Some of the files were located, but no all.

    I suppose if I locate these files and copy them to the C:\Windows\Installer folder, the issue would be resolved?

    Anyway, below is the list:

    Greg

     !!!! SQLSysClrTypes.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\redist\VisualStudioShell\SQLSysClrTypes\ !!!!
     !!!! SSCERuntime_x64-ENU.msi DOES NOT exist on the path in the path C:\Program Files (x86)\Microsoft SQL Server Compact Edition\Installer\ !!!!
     !!!! TSqlLanguageService_enu.msi DOES NOT exist on the path in the path J:\ !!!!
     !!!! DACFramework_enu.msi DOES NOT exist on the path in the path J:\ !!!!
     !!!! SharedManagementObjects.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\x86\ !!!!
     !!!! SqlRun_Tools.msi DOES NOT exist on the path in the path E:\SQL Server x64\Tools\Setup\ !!!!
     !!!! sqlls.msi DOES NOT exist on the path in the path p:\35061440922be4a53680b0ac4880\1033_ENU_LP\x64\setup\x64\ !!!!
     !!!! SQLServerBestPracticesPolicies.msi DOES NOT exist on the path in the path F:\1033_ENU_LP\x64\setup\ !!!!
     !!!! SSCEVSTools-enu.msi DOES NOT exist on the path in the path f:\wcu\ssce\ !!!!
     !!!! sql_dq.msi DOES NOT exist on the path in the path H:\x64\setup\ !!!!
     !!!! SqlPubWiz.msi DOES NOT exist on the path in the path f:\wcu\sqlpub\ !!!!
     !!!! SSCEVSTools-ENU.msi DOES NOT exist on the path in the path F:\vs90sp1\ !!!!
     !!!! rssharepoint.msi DOES NOT exist on the path in the path p:\35061440922be4a53680b0ac4880\1033_ENU_LP\x64\setup\ !!!!
     !!!! sql_dqc_loc.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\ !!!!
     !!!! SQLSysClrTypes.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\x86\ !!!!
     !!!! sqlmobile30devtoolsenu.msi DOES NOT exist on the path in the path e:\vs\wcu\SQLCE\ !!!!
     !!!! SharedManagementObjects.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\redist\VisualStudioShell\SMO\ !!!!
     !!!! SqlRun_SQL.msi DOES NOT exist on the path in the path E:\SQL Server x64\Servers\Setup\ !!!!
     !!!! masterdataservices.msi DOES NOT exist on the path in the path p:\35061440922be4a53680b0ac4880\x64\setup\ !!!!
     !!!! SQL_BOL_Components.msi DOES NOT exist on the path in the path H:\x64\setup\x64\ !!!!
     !!!! rsfx.msi DOES NOT exist on the path in the path F:\x64\setup\ !!!!
     !!!! sql_dreplay_controller.msi DOES NOT exist on the path in the path H:\x64\setup\ !!!!
     !!!! SharedManagementObjects_amd64_enu.msi DOES NOT exist on the path in the path J:\ !!!!
     !!!! sql_dreplay_client.msi DOES NOT exist on the path in the path H:\x64\setup\ !!!!
     !!!! sql_dreplay_client_loc.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\ !!!!
     !!!! sql_dqc.msi DOES NOT exist on the path in the path H:\x64\setup\ !!!!
     !!!! sql_dreplay_controller_loc.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\ !!!!
     !!!! SQL_BOL_Components_Loc.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\x64\ !!!!
     !!!! sqlserver2k5_bol.msi DOES NOT exist on the path in the path d:\d24c4ccb7e3a6071f1aa43\ !!!!
     !!!! SqlDom.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\x64\ !!!!
     !!!! sqlsupport.msi DOES NOT exist on the path in the path p:\35061440922be4a53680b0ac4880\1033_ENU_LP\x64\setup\sqlsupport_msi\ !!!!
     !!!! SqlRun_AS.msi DOES NOT exist on the path in the path E:\SQL Server x64\Servers\Setup\ !!!!
     !!!! sql_rsshp.msi DOES NOT exist on the path in the path H:\x64\setup\ !!!!
     !!!! masterdataservicesloc.msi DOES NOT exist on the path in the path p:\35061440922be4a53680b0ac4880\x64\setup\ !!!!
     !!!! TSqlLanguageService.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\x64\ !!!!
     !!!! sql_dq_loc.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\ !!!!
     !!!! sqlsupport.msi DOES NOT exist on the path in the path F:\1033_ENU_LP\x64\setup\sql2008support\ !!!!
     !!!! SQL_BOL_Registry_Loc.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\ !!!!
     !!!! sqlncli.msi DOES NOT exist on the path in the path p:\35061440922be4a53680b0ac4880\1033_ENU_LP\x64\setup\x64\ !!!!
     !!!! DACProjectSystemSetup_enu.msi DOES NOT exist on the path in the path J:\ !!!!
     !!!! SqlPubWiz.msi DOES NOT exist on the path in the path d:\b893137450c8988d0d\ !!!!
     !!!! SqlRun_RS.msi DOES NOT exist on the path in the path E:\SQL Server x64\Servers\Setup\ !!!!
     !!!! SSCERuntime_x64-enu.msi DOES NOT exist on the path in the path f:\wcu\ssce\ !!!!
     !!!! SharedManagementObjects.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\x64\ !!!!
     !!!! SQLSysClrTypes.msi DOES NOT exist on the path in the path F:\1033_ENU_LP\x64\setup\x64\ !!!!
     !!!! SSDTStub.msi DOES NOT exist on the path in the path H:\1033_ENU_LP\x64\setup\ !!!!
     !!!! sqlsqm.msi DOES NOT exist on the path in the path F:\x64\setup\ !!!!
     !!!! sql_dq_common.msi DOES NOT exist on the path in the path H:\x64\setup\ !!!!

  • Thursday, January 17, 2013 9:32 PM
     
     

    Here's a link cab file generated by the sp installation process.  It should be public  If not, let me know.

    https://skydrive.live.com/redir?resid=2A13D80897EF59FD!286&authkey=!ACKTQH0bUpJGBOA

    Greg

  • Wednesday, February 13, 2013 1:51 PM
     
     

    Well, I'm back to this issue.  Below in the pertinent text from the log file.  I have verified the installer file "2ff59dd.msi" is present in the installer folder.  This is a puzzler! This seems to indicate it has something to do with upgrading reporting services.

    Greg

    2013-01-09 08:25:38 Slp: Package sql_rs_Cpu64: - The path of cached MSI package is: C:\Windows\Installer\2ff59dd.msi . The RTM product version is: 10.50.1600.1
    2013-01-09 08:25:38 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.InitializeUIDataAction" threw an exception during execution.
    2013-01-09 08:25:38 Slp: Received request to add the following file to Watson reporting: b:\Temp\AppData\Local\Temp\tmp92B1.tmp
    2013-01-09 08:25:38 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2013-01-09 08:25:38 Slp: Inner exceptions are being indented
    2013-01-09 08:25:38 Slp:
    2013-01-09 08:25:38 Slp: Exception type: System.Resources.MissingManifestResourceException
    2013-01-09 08:25:38 Slp:     Message:
    2013-01-09 08:25:38 Slp:         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.
    2013-01-09 08:25:38 Slp:     Stack:
    2013-01-09 08:25:38 Slp:         at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)
    2013-01-09 08:25:38 Slp:         at System.Resources.ResourceManager.GetObject(String name, CultureInfo culture, Boolean wrapUnmanagedMemStream)
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Discovery.MsiException.GetErrorMessage(Int32 errorNumber, CultureInfo culture)
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Discovery.MsiException.GetErrorMessage(MsiRecord errorRecord, CultureInfo culture)
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Discovery.MsiException.get_Message()
    2013-01-09 08:25:38 Slp:         at System.Exception.ToString()
    2013-01-09 08:25:38 Slp:         at System.Exception.ToString()
    2013-01-09 08:25:38 Slp:         at System.Exception.ToString()
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.RunRequestedWorkflow()
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.Run()
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.Start()
    2013-01-09 08:25:38 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.Main()
    2013-01-09 08:26:14 Slp: Watson Bucket 1

  • Wednesday, February 13, 2013 10:31 PM
     
     Answered

    Well, I ended up uninstalling and reinstalling my SQL Server instance.

    • Marked As Answer by Greg Wilkerson Wednesday, February 13, 2013 10:31 PM
    •  
  • Friday, February 15, 2013 1:45 PM
     
     

    Hello Geg,

    We get this error message when there are missing msi/msp files in C:\Windows\Installer folder.

    If the issue is not related to missing cached files, then it could be becasue of corrupt msi/msp files in C:\Windows\Installer folder.