• DBA

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

    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…