Post reply

Win 2016 Core and SQL2016 Ent - Server Configuration Manager - WMI error, Done mofcomp

  • June 9, 2017 at 12:04 am

    #326420

    Hello i have a Windows 2016 Core and SQL 2016 Enterprise installed and i cannot get the remote management of SQL Server Configuration Manager to work.

    I have opened ports, disabled firewall, ran C:\Windows\SysWOW64\wbem\mofcomp.exe "c:\Program Files (x86)\Microsoft SQL Server\130\Shared\sqlmgmproviderxpsp2up.mof" without errors and restarted WMI service and all SQL services and even rebooted several times but i cannot connect.

    Error message:
    "Cannot connect to WMI Provider. You Do not have permission or the server is Unreachable."
    I have even added the domain account to the SQL database if its an authorization issue and added the administrative account with full permissions on the WMI security on every folder and item in the boxed area:

    The configuration file of SQL is set to:
    INSTALLSHAREDDIR="E:\Microsoft SQL Server"
    INSTALLSHAREDWOWDIR="E:\Microsoft SQL Server (x86)"

    But the .mof file is located in "c$\Program Files (x86)\Microsoft SQL Server\130\Shared"
    Is this normal?

    Maybe i need to reinstall and not specify the INSTALLSHAREDWOWDIR since it have split some directorys?

    Any tip is most welcome!

    Thanks
    HA4g3n
    Sweden

  • June 9, 2017 at 8:32 am

    #1946185

    I am receiving the same error with Windows 2012. The below link referencing a KB helped with one server but not another.

    https://www.mssqltips.com/sqlservertip/2492/why-is-sql-server-configuration-manager-missing-services/

    ¤ §unshine ¤

  • June 12, 2017 at 3:34 am

    #1946367

    sunshine-587009 - Friday, June 9, 2017 8:32 AM

    I am receiving the same error with Windows 2012. The below link referencing a KB helped with one server but not another.

    https://www.mssqltips.com/sqlservertip/2492/why-is-sql-server-configuration-manager-missing-services/

    Thanks for posting.

    I have now tried this post but with any success https://docs.microsoft.com/en-us/sql/ssms/configure-wmi-to-show-server-status-in-sql-server-tools
    Every post i found about this 
    is leading to the modcomp string and still no success..
    I have tried both these lines:

    C:\Windows\SysWOW64\wbem\mofcomp.exe "c:\Program Files (x86)\Microsoft SQL Server\130\Shared\sqlmgmproviderxpsp2up.mof"
    C:\Windows\System32\wbem\mofcomp.exe "c:\Program Files (x86)\Microsoft SQL Server\130\Shared\sqlmgmproviderxpsp2up.mof"

    I have rebuilt my WMI repository by stopping WMI service and deleted the folder %SystemRoot%\System32\Wbem\Repository and rebooted so the service is recreateing the files and the WMI is up and running.
    same error

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply