Troubleshooting: SQL Server Configuration Manager - Cannot connect to WMI provider
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
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|