Fix SQL Server Configuration Manager Error

on

 SQL Server Configuration Manager Error






Error :


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]


or


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 namespace [0x8004100e]



It generally happens if the WMI repository is corrupted or the sqlmgmprovider.dll file is not registered




To fix this follow the steps below:


(1) Open an elevated command prompt


(2) Run the following command, but make sure to replace <version> with the folder number that corresponds to your SQL Server version:






cd "C:\Program Files (x86)\Microsoft SQL Server\<version>\Shared"

mofcomp sqlmgmproviderxpsp2up.mof



Example here for SQL 2017:


cd "C:\Program Files (x86)\Microsoft SQL Server\140\Shared"

mofcomp sqlmgmproviderxpsp2up.mof



Now open the Configuration Manager as an administrator.


Note: This does not required an OS restart or a SQL service restart.


Click here for Microsoft Official Document


Enjoy !!!!!!!!!!!!!!!






 




Comments

Post a Comment