wmi error code 0x80070005

ilocaladventurer 1 Reputation point

access denied while adding my port number on alias on sql server configuration manager error code "0x80070005"

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,368 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,471 Reputation points Microsoft Employee

    Hi @ilocaladventurer ,
    The problem occurs because the Windows Management Instrumentation (WMI) provider configuration file for manage SQL Server services is missing. So the mofcomp command repairs or recreates it.

    First go to SQL Shared folder according to your sql version:

    SQL 2008: C:\Program Files (x86)\Microsoft SQL Server\100\Shared\
    SQL 2012: C:\Program Files (x86)\Microsoft SQL Server\110\Shared\
    SQL 2014: C:\Program Files (x86)\Microsoft SQL Server\120\Shared\
    SQL 2017: C:\Program Files (x86)\Microsoft SQL Server\140\Shared\
    SQL 2019: C:\Program Files (x86)\Microsoft SQL Server\150\Shared\ -------> My version is 2019

    Run Cmd as Administrator and execute these commands:

    cd "C:\Program Files (x86)\Microsoft SQL Server\150\Shared"  


    mofcomp sqlmgmproviderxpsp2up.mof  

    Here is more explanation: https://learn.microsoft.com/en-us/windows/desktop/wmisdk/mofcomp
    Best Regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments