Advertisements
Overview of the issue.
We had two SQL instances are installed in a server SQL 2008R2 and 2014 both instance configuration managers are not opened.
Error:
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.
Fix: Open drive where you have installed SQL, mostly C and navigate the folders and make sure you have file called – sqlmgmproviderxpsp2up.mof.
Run the following command in the CMD with run as administrator.
mofcomp “%programfiles(x86)%\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof”
Ex: 120 need to be changed for other versions.
2005-90
2008R2-100
2012-110
2014-120
2016-130
2017-140
2019-150
