Cannot connect to WMI provider. You do not have permission or the server cannot be accessed.

 

SQL configuration manager error, this is the next error.

Cannot connect to WMI provider. You do not have permission or the server cannot be accessed. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.

That error can occur from:

WNI provider: Sometimes this error occurs when the WMI provider is removed and the SQL server instance is uninstalled.

By privileges: Another reason that can happen when there are problems in privileges in the Windows registry. When Windows finds that the user does not have full access to the records.

In order to start with the possible solution, verify that the user account you are using is an administrator type account.

You can do these steps to resolve the problem.

These are the different versions of Microsoft SQL Server.

80 = Microsoft SQL Server 2000

90 = Microsoft SQL Server 2005

100 = Microsoft SQL Server 2008

105 = Microsoft SQL Server 2008 R2

110 = Microsoft SQL Server 2012

120 = Microsoft SQL Server 2014

130 = Microsoft SQL Server 2016

140 = Microsoft SQL Server 2017

150 = Microsoft SQL Server 2019

The first thing we must locate is the file sqlmgmproviderxpsp2up.mof, this file can be found in the following location, the folder "% Program Files (x86)% \ Microsoft SQL Server \ version of SQL \ Shared", we must search all the SQL server folder until the file is found.

Once the MOF file is found, you have to copy the full path of the Windows window where the MOF file is located, for example:

C: \ Program Files (x86) \ Microsoft SQL Server \ 110 \ Shared

Now we have the path, the next step is to open the Command Prompt "CMD", we execute it in administrator mode and we are going to write the following command:

Cd plus the path of the folder where the MOF file is located.

It would be as follows "cd C: \ Program Files (x86) \ Microsoft SQL Server \ 110 \ Shared", without the quotes we press enter.

The next step without closing Command Prompt "CMD", we write the following taken that is the most important for the problem to be repaired.

mofcomp sqlmgmproviderxpsp2up.mof

Note:

For this command to be successful, the Sqlmgmproviderxpsp2up.mof file must be present in the% Program Files (x86) % \ Microsoft SQL Server \ SQL \ Shared version folder.