page contents

About the Post

Author Information

Cannot connect to WMI provider. You do not have permission or the server is unreachable.

 

Recently, I had an issue where I installed SQL server with the default users to start the services. Later when I tried to change the service accounts to my active directory accounts, I got the following error message when trying to open SQL Server Configuration Manager.

 

I read that message “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]” a few times and then I went to my favorite search engine Bing to find the answer.

I found this article right away: 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

The reason that this problem occurs is due to the fact that I installed a 32 bit version of SQL Server (for testing) on a 64 bit OS. The problem is that SQL Server 2008 is always installed for both SQL Server 2012 and 2014 to help maintain backward compatibility to help with easier migrations of old SQL Server instances. Then it will open up the problem, because the WMI provider is removed when you uninstall an instance of SQL Server. (Both the 32-bit instance and 64-bit instance of SQL Server will share the same WMI configuration file. (This file is located in the %programfiles(x86)% folder)

To work around this problem, open a command prompt, type the following command, and then press ENTER:

mofcomp “%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof”

Note: For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.

The value of number (As seen below) depends on the version of SQL Server: number

This is the command that I ran on my SQL Server 2014 instance to resolve this issue:

mofcomp “%programfiles(x86)%\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof”

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\Windows\system32>mofcomp “%programfiles(x86)%\Microsoft SQL Server\120\Shared
\sqlmgmproviderxpsp2up.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 Server\120\Shared\sqlmgmp
roviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository…
Done!

C:\Windows\system32>

After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.

As usual, I hope this helps you!

 

Tags: , , , , , , , , , , ,

3 Responses to “Cannot connect to WMI provider. You do not have permission or the server is unreachable.”

  1. RSNewbie #

    Hi,
    I followed all your instructions but I still have 0x80041010 error.
    Here the different thing is that when I get into the correct directory, C:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsu2up.mof, the MOF file opens in Terminal (because I am using Parallel) and it says cannot execute binary file. I even restart wmimgmt service. But not successful. How do I overcome this issue? Any idea? Thanks in advanced.

    July 14, 2016 at 10:14 PM
    • Scott Mattie #

      What version of SQL Server are you using?

      July 15, 2016 at 11:25 AM
  2. I have problem with this.

    C:\Windows\System32\wbem>mofcomp “C:\Program Files (x86)\Microsoft SQL Server\12
    0\Shared\sqlmgmproviderxpsp2up.mof”
    Microsoft (R) MOF Compiler Version 6.2.9200.16398
    Copyright (c) Microsoft Corp. 1997-2006. Reservados todos los derechos.
    Analizando el archivo MOF: C:\Program Files (x86)\Microsoft SQL Server\120\Share
    d\sqlmgmproviderxpsp2up.mof
    El archivo MOF se analizó correctamente
    Almacenando información en el repositorio…
    Error al procesar el elemento 10 definido en las líneas 73 – 79 en el archivo C:
    \Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof:
    Número de error: 0x80070005, facilidad: Win32
    Descripción: Acceso denegado.
    El compilador ha devuelto el error 0x80070005
    C:\Windows\System32\wbem>

    What can I do?.
    .

    August 3, 2016 at 2:29 AM
Copy Protected by Chetan's WP-Copyprotect.