none
ReInstalling DPM keep failing and cant regonize our SQL Server 2008 R2 RRS feed

  • Question

  • Hi Everyone,

    I need your help please to fix our DPM 2012, it stopped working and I though of uninstalling it and then installing it again while keeping the data and configurations, the problem happen when I try to install it again, it keep showing me this error:

    the instance provided is not a SQL server 2008 R2 instance. please provide a SQL server 2008 R2 instance.

    but in fact the SQL server is 2008 R2 !

    any suggestions ?

    Thanks

    Misbah

    Thursday, September 5, 2013 4:46 PM

Answers

  • Hi,

    Yes, SQL WMI class is not registered.

    Re-register the WMI classes by running the Mofcomp command.

    C:\>mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    • Marked as answer by cool_misbah Thursday, September 5, 2013 6:11 PM
    Thursday, September 5, 2013 5:58 PM
    Moderator

All replies

  • Hi,

    DPM does WMI queries to check for SQL Server installation and version.

    Look in the DPMSETUP.LOG under C:\Program Files\Microsoft System Center 2012\DPM\DPMLogs and see what WMI query failed.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, September 5, 2013 5:05 PM
    Moderator
  • this is what I found in the log:

    Query WMI provider for SQL Server 2008.
    [9/5/2013 11:33:31 AM] Information : Querying WMI Namespace: \\systemcenter\root\Microsoft\SqlServer\ComputerManagement10 for query: Select * from SqlServiceAdvancedProperty where ServiceName='MSSQLSERVER' and PropertyName='Version'
    [9/5/2013 11:33:31 AM] * Exception :  => System.Management.ManagementException: Invalid class
       at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
       at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectHelper.GetSqlServerVersion(String instanceName, String sqlServerMachineName, ConnectionOptions wmiConnectionOptions)
    [9/5/2013 11:33:31 AM] * Exception : Expecting the following exception. Ignoring intentionally.  => System.Management.ManagementException: Invalid class
       at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
       at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectHelper.GetSqlServerVersion(String instanceName, String sqlServerMachineName, ConnectionOptions wmiConnectionOptions)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectHelper.DetectSqlServer(String instanceName, String sqlServerMachineName, ConnectionOptions wmiConnectionOptions)
    [9/5/2013 11:33:31 AM] Information : SQL Server 2008 MSSQLSERVER instance is not present on this system.
    [9/5/2013 11:33:31 AM] Information : Check if SQL Server 2008 Tools is installed.
    [9/5/2013 11:33:31 AM] Information : Inspect.CheckSqlServerTools : MsiQueryProductState returned : INSTALLSTATE_DEFAULT
    [9/5/2013 11:33:31 AM] Information : SQL Server 2008 Tools is installed

    Thursday, September 5, 2013 5:19 PM
  • Hi,

    Yes, SQL WMI class is not registered.

    Re-register the WMI classes by running the Mofcomp command.

    C:\>mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    • Marked as answer by cool_misbah Thursday, September 5, 2013 6:11 PM
    Thursday, September 5, 2013 5:58 PM
    Moderator
  • Thanks so much!, this fixed the issue :)
    Thursday, September 5, 2013 6:11 PM
  • I got the same wmi issue but re-registering the mof did not fix the issue.

    [22/11/2013 8:11:17 AM] Information : Query WMI provider for SQL Server 2008.
    [22/11/2013 8:11:17 AM] Information : Querying WMI Namespace: \\sqlserver\root\Microsoft\SqlServer\ComputerManagement10 for query: Select * from SqlServiceAdvancedProperty where ServiceName='MSSQL$infra08, 1400' and PropertyName='Version'
    [22/11/2013 8:11:19 AM] Information : SQL Server 2008 infra08, 1400 instance is not present on this system.

    Any other suggestions?

    thanks


    • Edited by Wan2011 Thursday, November 21, 2013 9:21 PM
    Thursday, November 21, 2013 9:18 PM