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

From AutoCount Resource Center

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]"

Version: 1.8 / 1.9 / 2.0


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.



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.



BY:CY 180811, KM 170814, P170816

Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations