cannot connect to wmi provider

I cant open my SQL server configuration manager getting this error message:

I have searched online material and ran the mofcomp command as recommended: mofcomp “C:Program Files (x86)Microsoft SQL Server120Sharedsqlmgmproviderxpsp2up.mof”

I am now getting this error message:

Can you please help me out, been 2 weeks sited with this problem

5 Answers 5

Run Cmd as Administrator and execute this commands:

first go to SQL folder according to your sql version:

SQL 2008: C:Program Files (x86)Microsoft SQL Server100Shared
SQL 2012: C:Program Files (x86)Microsoft SQL Server110Shared
SQL 2014: C:Program Files (x86)Microsoft SQL Server120Shared
SQL 2017: C:Program Files (x86)Microsoft SQL Server140Shared —-> Mine is 2017

Очередь просмотра

Очередь

  • Удалить все
  • Отключить

YouTube Premium

Хотите сохраните это видео?

  • Пожаловаться

Пожаловаться на видео?

Выполните вход, чтобы сообщить о неприемлемом контенте.

Понравилось?

Не понравилось?

Error message when you open SQL Server Configuration Manager in SQL Server: «Cannot connect to WMI provider. You do not have permission or the server is unreachable».

If You run at win 64, the directory is different

Possible SQL version’s shared directory:

SQL 2008: C:Program Files (x86)Microsoft SQL Server90Shared
SQL 2008 R2: C:Program Files (x86)Microsoft SQL Server100Shared
SQL 2012: C:Program Files (x86)Microsoft SQL Server110Shared
SQL 2014: C:Program Files (x86)Microsoft SQL Server120Shared
SQL 2017: C:Program Files (x86)Microsoft SQL Server140Shared

Sharing my knowlege about SQL Server Troubleshooting Skills

Blog Stats

  • 1,695,071 hits
  • Blogroll

    Select GETDATE()

    November 2019
    M T W T F S S
    « Apr
    1 2 3
    4 5 6 7 8 9 10
    11 12 13 14 15 16 17
    18 19 20 21 22 23 24
    25 26 27 28 29 30

    Subscribe

    Follow Blog via Email

    Solution : SQL Server Configuration Manager – Cannot connect to WMI prov >Posted by blakhani on February 3, 2015

    One of my friend had something wrong with SQL Server installation. He did multiple things like repair, registry cleanup etc. I helped him in cleaning up stuff and reinstalling SQL Server. Things were looking good but there was one pending issue.

    As soon as he was trying to launch SQL Server Configuration Manager, he was seeing below error.

    —————————
    SQL Server Configuration Manager
    —————————
    Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
    Provider load failure [0x80041013]
    —————————
    OK
    —————————

    Another variation of same error is The specified module could not be found. [0x8007007e] – This clearly indicates that some dll is not registered.

    He found this KB http://support.microsoft.com/kb/980142 but he was on SQL 2008 SP3 so this was not applicable. Since there was many things done by him, I was almost sure that this is due to either missing DLL or some WMI provider related files. Below were the steps performed to fix the issue.

    • We need to make sure that we have sqlmgmprov >

    Microsoft SQL Server 2014

    Microsoft SQL Server 2012

    Microsoft SQL Server 2008 R2

    Microsoft SQL Server 2008

    Microsoft SQL Server 2005

    • If file is present in the folder, please register the DLL using command (regsvr32.exe «C:Program FilesMicrosoft SQL Server110Sharedsqlmgmprovider.dll»)
    • Make sure we have file “svrenumapi.dll” in the same folder. If file exists, register it using regsrv32.exe as pointed earlier. In SQL 2014 the file is called as svrenumapi12.dll
    • Make sure that file framedyn.dll exists in “C:WINDOWSsystem32” folder. If not, pick it from C:WINDOWSsystem32wbem folder and keep it to system32.
    • Check your environment variables. the PATH variable has C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem

    If none of the above is working then you should download Process Monitor and capture data while launching SQL Server Configuration Manager. Look for “Name not found” and that might give you some hint. Comment below if you found any other solution

    Solution: Unable to launch SQL Server Configuration Manager – Inval >Posted by blakhani on September 4, 2014

    While launching SQL Server Configuration Manager on one of my machine, I got below error

    Here is the text of the error message:

    —————————
    SQL Server Configuration Manager
    —————————
    Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
    Invalid class [0x80041010]
    —————————
    OK
    —————————

    There might be various reason for this error. In this case our actual problem is “Inval >Invalid namespace [0x8004100e] error also.

    C:WINDOWSsystem32> mofcomp » C:Program Files (x86)Microsoft SQL Server120Sharedsqlmgmproviderxpsp2up.mof »
    Microsoft (R) MOF Compiler Version 6.3.9600.16384
    Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
    Parsing MOF file: C:Program Files (x86)Microsoft SQL Server120Sharedsqlmgmproviderxpsp2up.mof
    MOF file has been successfully parsed
    Storing data in the repository…
    Done!

    MofComp is a command line utility to compile MOF (Managed Object Format) files and store the data in WMI repository. The MOF Compiler is available in the %Windir%System32wbem directory. So if you are getting “‘mofcomp’ is not recognized as an internal or external command then try changing current directory from command prompt to %Windir%System32wbem

    Also note that in mof file on my machine is under 120 folder. Depends on SQL version installed, you may have it in different folder. The value of that number depends on the version of SQL Server.

  • Оцените статью