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"
mofcomp "%programfiles(x86)%\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"
Ref:-
No comments:
Post a Comment