wmi error code 0x80070005

ilocaladventurer 1 Reputation point
2021-09-09T09:47:17.82+00:00

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,796 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-09-10T01:53:42.537+00:00

    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"

    Then: 

    mofcomp sqlmgmproviderxpsp2up.mof

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

    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