SQL Server Cannot Connect to WMI Provider, No Permission
We have SQL Server Management Studio 2012 Express works well, but when we tried to launch SQL Server Configuration Manager, we got the following error message:
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manager SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]
Microsoft official site provides a related information mentions this might be caused by a previous instance of SQL Server uninstalled. The same WMI configuration file is shared by both of 32-bit SQL Server instance and 64-bit SQL Server instance. This file should be located in the folder This file is located in the %programfiles(x86)% .
The WMI is Windows Management Instrumentation service.
Anyway, let us try to resolve this issue.
1: Open a command window. On our case we open the Command Prompt (Admin) on our Windows 8 system:
2: Run the following command due to your SQL Server version:
Our version is SQL Server 2012 Express, then we use the following one:
mofcomp "C:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"
The number 110 in the command is just for SQL Server 2012. If you have SQL Server 2008, the number should be 100, and SQL Server 2005 should be 90;
We got the successful result after run above command:
3: Now we should restart the WMI service in Windows:
Open the Services viewer, if you do not know where is the Services viewer, just search Services in your windows search toolbox and choose Local Services View. You will see the Window like the following one, find the service Windows Management Instruments (WMI), right click it and select Restart:
You will see the restart process will restart related services, just do it and wait for the restarting process finished.
4: Now you try to run the SQL Server Configuration Manager, you will see it can run now.