Troubleshooting: SQL Server Configuration Manager - Cannot connect to WMI provider

From AutoCount Resource Center
Jump to navigation Jump to search

Question: When I open SQL Server Configuration Manager, get error message as below:

"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 [0x80041010]"


Wmi1.png


Possible Reason:

On a 64-bit computer, you install both 32-bit and 64-bit versions of Microsoft SQL Server instances. If you then uninstall the either one of the instances, you receive the error message as mentioned when you open SQL Server Configuration Manager.


Solution:

Step 1: Go to Start Menu, search for “CMD.exe” and press Enter.


Wmi2.png


Step 2: From the following command, replace the value of version according to your version of SQL Server installed. Then copy the entire command.

For SQL 32bit:

mofcomp "%programfiles(x86)%\Microsoft SQL Server\version\Shared\sqlmgmproviderxpsp2up.mof"

For SQL 64bit:

mofcomp "%programfiles%\Microsoft SQL Server\version\Shared\sqlmgmproviderxpsp2up.mof"


SQL Version:

SQL Server Version Database Version
Microsoft SQL Server 2017 140
Microsoft SQL Server 2016 130
Microsoft SQL Server 2014 120
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90


Step 3: Paste the command into CMD and press Enter. Wait for it to process until you see the “Done!” message, then you may close the CMD and restart your computer to take effect.


Wmi3.png


BY:CY 180811, KM 170814, P170816

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations