Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Archive for October, 2017

WMI broken FCI or SQL Server

Posted by Simon Cho on 10/23/2017

Get-WmiObject -namespace "root\mscluster" -class MSCluster_Resource

Get-WmiObject : Invalid namespace

mofcomp C:\Windows\System32\wbem\ClusWMI.mof

PS C:\Windows\system32> mofcomp C:\Windows\System32\wbem\ClusWMI.mof
Microsoft (R) MOF Compiler Version 6.2.9200.16398
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: C:\Windows\System32\wbem\ClusWMI.mof
MOF file has been successfully parsed
Storing data in the repository…
Done!

 

 

Here is for SQL Server WMI issue.
Expected error message when WMI doesn’t registered properly.

The following exception occurred while trying to enumerate the collection: "An exception occurred in SMO while trying to manage a service.".
At line:xx char:xxx
+ $wmi.xxxx
+ ~~~~~~~~~~~~~~~~~~~~
 + CategoryInfo : NotSpecified: (:) [], ExtendedTypeSystemException
 + FullyQualifiedErrorId : ExceptionInGetEnumerator

Another error message when open SQL configuration manage.

Cannot connect to WMI provider. You do not have permission or the server is unreachable

 

 

 

 

 

 

 

 

 

<Solution>

Please check path and Version number in below script.

//SQL 2008
mofcomp "%programfiles(x86)%\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
//SQL 2012
mofcomp "%programfiles(x86)%\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"
//SQL 2014
mofcomp "%programfiles(x86)%\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof"
//SQL 2016
mofcomp "%programfiles(x86)%\Microsoft SQL Server\130\Shared\sqlmgmproviderxpsp2up.mof"
//SQL 2017
mofcomp "%programfiles(x86)%\Microsoft SQL Server\140\Shared\sqlmgmproviderxpsp2up.mof"

Posted in Common | Tagged: , , | Leave a Comment »

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.

Posted by Simon Cho on 10/23/2017

https://www.linkedin.com/pulse/how-fix-sql-server-configuration-manager-cannot-connect-mohamed-fekry/

 

Posted in Common | Leave a Comment »