SQL Server 2008 R2 Instances WMI Error

• Skyscraper76

  Valued Member

  Points: 65

  More actions

  September 13, 2013 at 6:57 am

  #277973

  Hi there,

  I have 2 clustered Windows Servers 2012 for SQL Server Instances. I have no shared disks because, I use the cluster with SQL Always on. On each node there is one SQL Server 2008 R2 and two SQL Server 2012 SP1 instances.

  On my nodes wbemtest.exe could not query in the “root\Microsoft\SqlServer\ComputerManagement10″ Namespace "select * from SqlService where SQLServiceType ='1'". Error: 0×80010105 RPC The Server threw an exeption.

  This is important for me , because I want to use System Center Operations Manager (SCOM) Monitoring. Without that the SQL 2008 Instance is not discovered by SCOM.

  When I query against “root\Microsoft\SqlServer\ComputerManagement11″ all instances are visible.

  So, I think it is an WMI Problem with Windows Server 2012.

  I had the same error, when I set up my cluster with SQL Server in the SQL Config Manager.

  http://support.microsoft.com/kb/2849344/de gave me the solution for that.

  Restart the WMI Service did not solve my problem.

  Thanks for help.