SSCM – Cannot Connect to WMI Provider

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.

ref: https://support.microsoft.com/en-gb/help/956013/error-message-when-you-open-sql-server-configuration-manager-in-sql-se

-Hari Mindi