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”.

Access denied cmd1.png

Possible Reason :

The current user does not have permission to perform the action.

Solution :

1) Right click on Command Prompt and Run as administrator.

Access denied cmd2.png

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

Go to menu

  AutoCount Accounting 2.0

  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS

  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations