DBA

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

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

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

Your email address will not be published.

WC Captcha 2 + 3 =