SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider
When you try to open SQL Server Configuration you get the below error:
Cannot connect to WMI provider. You do not have permission or the server is unreachable.
This can happen due to many reasons:
- On a 64-bit machine, you have installed 32-bit SQL Server version.
- You installed a 64-bit SQL Server and uninstalled it later.
Fix:
Open command prompt as administrator
Right click on CMD prompt — click on RUN AS ADMINISTRATOR
Type the below command and press ENTER:
mofcomp “%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof”
Replace number with the SQL Server version number:
- SQL Server 2017 – 140
- SQL Server 2016 – 130
- SQL Server 2014 – 120
- SQL Server 2012 – 110
- SQL Server 2008 or R2 – 100
If you get ACCESS DENIED message when you run the above command, you did not open CMD prompt as administrator.
Let me know if this is helpful.
-Hari Mindi
0 Comments