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

From AutoCount Resource Center
Revision as of 07:00, 13 October 2017 by Keatmeng (talk | contribs) (Created page with "<b>Question:</b> 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 unreac...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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



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 SQLServer\version\Shared\sqlmgmproviderxpsp2up.mof"

For SQL 64bit:

mofcomp "%programfiles%\Microsoft SQLServer\version\Shared\sqlmgmproviderxpsp2up.mof"


SQL Version:


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