none
MOF Syntax error with SQL server 2005 and 2008 R2 resolution?

    Question

  • I have a Windows XP SP3 PC that previously had SQL Server 2008 Express with advanced services installed.  I removed that instance with the intent to replace it with a full SQL Server 2008 R2 developer edition.  Instead, all my attempts to complete a setup are resulting in a MOF syntax error.  I have tried SQL Servers 2005, 2008, 2008 R2 and 2008 Express with Management Tools.

    I have downloaded the latest update for SQL Server 2008 (CU9 released August 11th, 2011) and followed the instructions in KB955392 to update my install media, but still no luck.

    The error is:

    2011-10-06 13:44:04 Slp: Attempting to install MOF/MFL file for WMI Provider c:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof
    2011-10-06 13:44:04 Slp: Sco: Attempting to install MOF file
    2011-10-06 13:44:04 Slp: Running: C:\WINDOWS\system32\WBEM\mofcomp.exe "c:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
    2011-10-06 13:44:04 Slp: Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.5512
    2011-10-06 13:44:04 Slp: Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
    2011-10-06 13:44:04 Slp: Parsing MOF file: c:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof
    2011-10-06 13:44:04 Slp: MOF file has been successfully parsed
    2011-10-06 13:44:04 Slp: Storing data in the repository...
    2011-10-06 13:44:04 Slp: An error occurred while processing item 3 defined on lines 16 - 19 in file c:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof:
    2011-10-06 13:44:04 Slp: 0X80041002 Class, instance, or property 'Name' was not found.
    2011-10-06 13:44:04 Slp: Compiler returned error 0x80041001
    2011-10-06 13:44:04 Slp: Sco: Compile operation for mof file c:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof failed. Exit code 3
    2011-10-06 13:44:04 Slp: Configuration action failed for feature CommonFiles during timing ConfigNonRC and scenario ConfigNonRC.
    2011-10-06 13:44:04 Slp: A MOF syntax error occurred.
    2011-10-06 13:44:04 Slp: The configuration failure category of current exception is ConfigurationFailure
    2011-10-06 13:44:04 Slp: Configuration action failed for feature CommonFiles during timing ConfigNonRC and scenario ConfigNonRC.
    2011-10-06 13:44:04 Slp: Microsoft.SqlServer.Configuration.Sco.ScoException: A MOF syntax error occurred.
    2011-10-06 13:44:04 Slp:    at Microsoft.SqlServer.Configuration.Sco.WmiProvider.InstallMof()
    2011-10-06 13:44:04 Slp:    at Microsoft.SqlServer.Configuration.Slp.SlpConfigurationPrivate.Install_ConfigWMIProvider(Dictionary`2 actionData)
    2011-10-06 13:44:04 Slp:    at Microsoft.SqlServer.Configuration.Slp.SlpConfigurationPrivate.Install_PostMSI(Dictionary`2 actionData, PublicConfigurationBase spcb)
    2011-10-06 13:44:04 Slp:    at Microsoft.SqlServer.Configuration.Slp.SlpConfigurationPrivate.InstallImpl(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
    2011-10-06 13:44:04 Slp:    at Microsoft.SqlServer.Configuration.Slp.SlpConfigurationPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
    2011-10-06 13:44:04 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    2011-10-06 13:44:04 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
    2011-10-06 13:44:04 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
    2011-10-06 13:44:04 Slp: Exception: Microsoft.SqlServer.Configuration.Sco.ScoException.
    2011-10-06 13:44:04 Slp: Source: Microsoft.SqlServer.Configuration.Sco.
    2011-10-06 13:44:04 Slp: Message: A MOF syntax error occurred..
    2011-10-06 13:44:04 Slp: Watson Bucket 1

    The MOF snippet that is listed in the error:

    #pragma namespace("\\\\.\\root\\Microsoft\\SqlServer")

    Instance of __Namespace
    {
      Name = "ComputerManagement10";
    };

     

    I am at my wits end on this one and appreciate any help or ideas I can get.

    Steven

    Thursday, October 06, 2011 10:11 PM

Answers

  • I got my issue, resolved, although I did a trouble-shooting no-no.  I changed several variables. . .one of these 3 things did the trick:

    1) I repaired my .NET 3.5 SP1 install

    2) I ran the Microsoft 'fix-it' to try to get SQL to install.  However, this made things worse for a while.  This removed some of the SQL install, but not all of it.  Then SQL wouldn't install (kept failing the rule check for computer restart), and the partial install wouldn't un-install.  I ran 'fix-it' again this time telling it to fix my SQL un-install problem, which it did successfully.

    3) Successfully installed SQL Server 2008 Standard edition.  Not sure if this matters or not.  I had already tried several other versions of SQL with no luck.

    If I had to guess, I'd say the .NET 3.5 repair did the trick.

    Steven

    • Marked as answer by Peja Tao Tuesday, October 11, 2011 12:56 AM
    Monday, October 10, 2011 11:36 PM

All replies

  • Hello,

    This is a known issue, please repair WMI.

    http://windowsxp.mvps.org/repairwmi.htm

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


    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Peja Tao Friday, October 07, 2011 7:56 AM
    Friday, October 07, 2011 1:08 AM
    Moderator
  • Alberto,

    I appreciate the response!  I had high hopes as when I ran WMI checker, it complained about a missing SQL dll (sqlmgmprovider.dll), so I followed the instructions provided by the tool as well as the instructions to rebuild my WMI respository.  The tool now comes back clean, however, it had no effect, the MOF error is still plaguing my SQL install.

    Steven

    Monday, October 10, 2011 6:38 PM
  • I got my issue, resolved, although I did a trouble-shooting no-no.  I changed several variables. . .one of these 3 things did the trick:

    1) I repaired my .NET 3.5 SP1 install

    2) I ran the Microsoft 'fix-it' to try to get SQL to install.  However, this made things worse for a while.  This removed some of the SQL install, but not all of it.  Then SQL wouldn't install (kept failing the rule check for computer restart), and the partial install wouldn't un-install.  I ran 'fix-it' again this time telling it to fix my SQL un-install problem, which it did successfully.

    3) Successfully installed SQL Server 2008 Standard edition.  Not sure if this matters or not.  I had already tried several other versions of SQL with no luck.

    If I had to guess, I'd say the .NET 3.5 repair did the trick.

    Steven

    • Marked as answer by Peja Tao Tuesday, October 11, 2011 12:56 AM
    Monday, October 10, 2011 11:36 PM