Monday, October 14, 2019

SQL Server Configuration Manager Cannot Connect to WMI Provider

Problem:- 
Hi, when trying to open SQL Server Configuration Manager and it won’t with below error use the below script based on the SQL version to fix it and it will open normally.


Error:-
---------------------------       
SQL Server Configuration Manager
---------------------------
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.
Invalid class [0x80041010]
---------------------------
OK  
---------------------------


Solution:-
Run Below in CMD or Powershell as Admin

#SQLServer 2016#
mofcomp "%programfiles(x86)%\Microsoft SQL Server\130\Shared\sqlmgmproviderxpsp2up.mof"

#SQLServer 2014#
mofcomp "%programfiles(x86)%\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof"

#SQLServer 2012#
mofcomp "%programfiles(x86)%\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"

#SQLServer 2008 & 2008R2#
mofcomp "%programfiles(x86)%\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

#SQLServer 2005#
mofcomp "%programfiles(x86)%\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"



Ref:-

No comments:

Post a Comment