Troubleshooting: Access Denied when run command prompt: Difference between revisions
(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”.
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
|