Troubleshooting: Access Denied when run command prompt
Question: When I open SQL Server Configuration Manager, error prompted “Cannot connect to WMI provider”. I follow the guidelines in wiki, but in command prompt shown “Access Denied”.
Possible Reason :
The current user does not have permission to perform the action.
Solution :
1) Right click on Command Prompt and Run as administrator.
2) Paste the command into the command prompt and press Enter.
For SQL 32bit:
cd "C:\Program Files (x86)\Microsoft SQL Server\version\Shared"
For SQL 64bit:
cd "C:\Program Files\Microsoft SQL Server\version\Shared"
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 |
3) Paste the command into the command prompt and press Enter.
mofcomp sqlmgmproviderxpsp2up.mof
Now you should be able to open SQL Server Configuration Manager.
By: Christine 210919, Lay Swan 210927, P210928
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
|