Troubleshooting: SQL Server Configuration Manager - Cannot connect to WMI provider: Difference between revisions
No edit summary |
No edit summary |
||
(One intermediate revision by one other user not shown) | |||
Line 4: | Line 4: | ||
Invalid namespace [0x80041010]" |
Invalid namespace [0x80041010]" |
||
<b>Version:</b> 1.8 / 1.9 / 2.0 |
|||
[[File:Wmi1.png]] |
[[File:Wmi1.png]] |
||
Line 37: | Line 38: | ||
|- |
|- |
||
!SQL Server Version !! Database Version |
!SQL Server Version !! Database Version |
||
|- |
|||
| Microsoft SQL Server 2017 || 140 |
|||
|- |
|||
| Microsoft SQL Server 2016 || 130 |
|||
|- |
|- |
||
| Microsoft SQL Server 2014|| 120 |
| Microsoft SQL Server 2014|| 120 |
Latest revision as of 02:24, 24 February 2020
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 2.0 & 2.1
|
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|