Troubleshooting: Access Denied when run command prompt: Difference between revisions

From AutoCount Resource Center
(Created page with "'''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...")
 
No edit summary
 
Line 25: Line 25:
 
<span style='color:red'>cd "C:\Program Files\Microsoft SQL Server\version\Shared"</span><br/>
 
<span style='color:red'>cd "C:\Program Files\Microsoft SQL Server\version\Shared"</span><br/>
   
  +
  +
<b>SQL Version:</b>
  +
  +
{| class="wikitable"
  +
|-
  +
!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
  +
|-
  +
  +
|}
   
   

Latest revision as of 09:39, 30 September 2021

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

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations