none
SQL Server 2008 R2 Setup Error: A MOF syntax error occurred.

    Question

  • I'm trying to install SQL Server 2008 R2 and I'm getting the following error:

    2011-04-06 15:13:22 Slp: Storing data in the repository...
    2011-04-06 15:13:23 Slp: An error occurred while creating object 1 defined on lines 14 - 16:
    2011-04-06 15:13:23 Slp: 0X80041002 Class, instance, or property 'EventTrace' was not found.
    2011-04-06 15:13:23 Slp: Compiler returned error 0x80041002
    2011-04-06 15:13:23 Slp: Sco: Compile operation for mof file C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\etwcls.mof.transformed failed. Exit code 3
    2011-04-06 15:13:23 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
    2011-04-06 15:13:23 Slp: A MOF syntax error occurred.
    2011-04-06 15:13:23 Slp: The configuration failure category of current exception is ConfigurationFailure
    2011-04-06 15:13:23 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
    2011-04-06 15:13:23 Slp: Microsoft.SqlServer.Configuration.Sco.ScoException: A MOF syntax error occurred.
    2011-04-06 15:13:23 Slp:    at Microsoft.SqlServer.Configuration.Sco.WmiProvider.InstallMof()
    2011-04-06 15:13:23 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.EtwSetup.Install(String strInstanceName, Guid guidInstance, String strPath)
    2011-04-06 15:13:23 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.SetupETW(EffectiveProperties properties)
    2011-04-06 15:13:23 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install_ConfigNonRC_Prepare(EffectiveProperties properties)
    2011-04-06 15:13:23 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
    2011-04-06 15:13:23 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
    2011-04-06 15:13:23 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
    2011-04-06 15:13:23 Slp: Exception: Microsoft.SqlServer.Configuration.Sco.ScoException.
    2011-04-06 15:13:23 Slp: Source: Microsoft.SqlServer.Configuration.Sco.
    2011-04-06 15:13:23 Slp: Message: A MOF syntax error occurred..
    2011-04-06 15:13:23 Slp: Watson Bucket 1

    I did have SQL Server 2008 / Sql Express installed. The upgrade failed. So I uninstalled both instances / programs, removed directories / reg entries.  Clean install fails with same message.  All checks pass durning setup.  Arg!

    Suggestions?


    Thanks,
    Carl
    Wednesday, April 06, 2011 10:26 PM

Answers

  • Okay, I got SQL Server 2008 R2 installed.   I missed your slipstream comment last night.

    I noticed that it was Reporting Services that was failing to install.  So I just installed SQL Server engine, then applied the above SP, then installed the rest of SQL Server features.

    I personally believe applying the hotfix is a red heiring (does not applied for this issue). I think the real issue is which service account one selects during setup for Reporting Services.  If one selects a different one than what is being used (for upgrades), or selects System (and not Network Services).  I also noticed that in ether case, the service account dropdown includes an odd entry:  NetworkServices vs Network Services (note the space between the two words). I'm not 100% this is the issue, but once I selected "Network Services" (with a space) as the user account for Reporting Services, it installed correctly. 

    ***************

    Now Visual Studio 2010 is broken! Seems when one applies SQL Server R2, it breaks Visual Studio 2010 DAC compoents.
    http://connect.microsoft.com/VisualStudio/feedback/details/532121/tons-of-package-did-not-load-correctly-errors

    I need to find my VS 2010 disks and reinstall the following:

    - Install the following three packages from the Visual Studio 2010 installation DVD / CD.
    Microsoft SQL Server 2008 R2 Data-Tier Application Framework with this command:
    \WCU\DAC\DACFramework_enu.msi

    Microsoft SQL Server 2008 R2 Data-Tier Application Project:
    \WCU\DAC\DACProjectSystemSetup_enu.msi

    Microsoft SQL Server 2008 R2 Transact-SQL Language Service:
    \WCU\DAC\TSqlLanguageService_enu.msi


    Thanks, Carl
    Thursday, April 07, 2011 4:10 PM

All replies

  • Hello,

    Please see the following resource:

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

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Peja Tao Friday, April 08, 2011 6:52 AM
    Wednesday, April 06, 2011 10:31 PM
    Moderator
  • Hi Alberto,
    After reading the above KB article, it appears I need to install  

    Cumulative Update package 5 for SQL Server 2008 R2
    http://support.microsoft.com/kb/2438347 

    Clicking the "View and request hotfix downloads" sends me to
    http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2438347&kbln=en-us

    where I can request to download the following

      SQL Server 2008 R2 All (Global) x64 nosp 2008R2_RTM_SNAC_CU5_2438347_10_50_1753_x64 2008 R2 10.50.1753.0 6942880 12/17/2010 6:15:13 PM
      SQL Server 2008 R2 All (Global) x64 nosp 2008R2_RTM_MDS_CU5_2438347_10_50_1753_x64 2008 R2 10.50.1753.0 12224768 12/17/2010 6:15:13 PM
      SQL Server 2008 R2 All (Global) x64 nosp 2008R2_RTM_PPExcel_CU4_2438347_10_50_1753_x64 2008 R2 10.50.1753.0 112696549 12/28/2010 7:15:39 PM
      SQL Server 2008 R2 All (Global) x64 nosp 2008R2_RTM_RSShrPnt_CU5_2438347_10_50_1753_x64 2008 R2 10.50.1753.0 37163517 12/17/2010 6:15:12 PM
      SQL Server 2008 R2 All (Global) x64 nosp 2008R2_RTM_SapBI_CU5_2438347_10_50_1753_x64 2008 R2 10.50.1753.0 1872840 12/17/2010 6:15:12 PM
      SQL Server 2008 R2 All (Global) x64 nosp SQLServer2008R2_RTM_CU5_2438347_10_50_1753_x64


    After download them via links in email sent to me (and entering password for each), all installed except the last one. It errored out with the following

    TITLE: SQL Server Setup failure.
    ------------------------------
    SQL Server Setup has encountered the following error:
    A failure was detected for a previous installation, patch, or repair for instance 'MSSQLSERVER' during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,RS_Server_Adv,]. In order to apply this patch package (KB2438347), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.
    Error code 0x84B20001.


    Repair fails on the main instance (items were not installed).
    So I uinstall the main instance.
    i then run the above hotfix again and it fails with same error (0x84B20001). Arg!!!

    Do I need to uninstall all of SQL Server again (including directories/registry)?
    If SQL Server is not installed, then how is the above hotfix going to help?

    HELP!!!

     

    Wednesday, April 06, 2011 11:51 PM
  • Hello,

    Please update the original media with cumulative update 5 using slipstream, then install SQL Server again.

    http://support.microsoft.com/kb/955392 (applies to SQL Server 2008 R2 also)

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

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, April 07, 2011 1:47 AM
    Moderator
  • Okay, I got SQL Server 2008 R2 installed.   I missed your slipstream comment last night.

    I noticed that it was Reporting Services that was failing to install.  So I just installed SQL Server engine, then applied the above SP, then installed the rest of SQL Server features.

    I personally believe applying the hotfix is a red heiring (does not applied for this issue). I think the real issue is which service account one selects during setup for Reporting Services.  If one selects a different one than what is being used (for upgrades), or selects System (and not Network Services).  I also noticed that in ether case, the service account dropdown includes an odd entry:  NetworkServices vs Network Services (note the space between the two words). I'm not 100% this is the issue, but once I selected "Network Services" (with a space) as the user account for Reporting Services, it installed correctly. 

    ***************

    Now Visual Studio 2010 is broken! Seems when one applies SQL Server R2, it breaks Visual Studio 2010 DAC compoents.
    http://connect.microsoft.com/VisualStudio/feedback/details/532121/tons-of-package-did-not-load-correctly-errors

    I need to find my VS 2010 disks and reinstall the following:

    - Install the following three packages from the Visual Studio 2010 installation DVD / CD.
    Microsoft SQL Server 2008 R2 Data-Tier Application Framework with this command:
    \WCU\DAC\DACFramework_enu.msi

    Microsoft SQL Server 2008 R2 Data-Tier Application Project:
    \WCU\DAC\DACProjectSystemSetup_enu.msi

    Microsoft SQL Server 2008 R2 Transact-SQL Language Service:
    \WCU\DAC\TSqlLanguageService_enu.msi


    Thanks, Carl
    Thursday, April 07, 2011 4:10 PM