SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider

When you try to open SQL Server Configuration you get the below error:

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

This can happen due to many reasons:

  • On a 64-bit machine, you have installed 32-bit SQL Server version.
  • You installed a 64-bit SQL Server and uninstalled it later.

Fix:

Open command prompt as administrator

Right click on CMD prompt  — click on RUN AS ADMINISTRATOR

Type the below command and press ENTER:

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

Replace number with the SQL Server version number:

  • SQL Server 2017 – 140
  • SQL Server 2016 – 130
  • SQL Server 2014 – 120
  • SQL Server 2012 – 110
  • SQL Server 2008 or R2 – 100

If you get ACCESS DENIED message when you run the above command, you did not open CMD prompt as administrator.

Let me know if this is helpful.

ref: https://support.microsoft.com/en-gb/help/956013/error-message-when-you-open-sql-server-configuration-manager-in-sql-se

-Hari Mindi

 


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.