Cannot connect to WMI provider

Created by QNE Software Sdn bhd, Modified on Mon, 5 Dec, 2022 at 1:38 PM by QNE Software Sdn bhd

Scenario 

Open SQL Server Configuration Manager in SQL Server prompt

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

 

SQL Server Configuration Manager use Window Management Instrumentation (WMI) to view and change some server settings. When connecting to servers, SQL Server Configuration Manager uses WMI to obtain the status of the SQL Server (MSSQLSERVER) and SQL Server Agent services. This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server.

 

This file is located in the %programfiles(x86)% folder.

Solution 

1. The MOF file (sqlmgmproviderxpsp2up.mof) for your SQL instance is found in "%programfiles(x86)%\Microsoft SQL Server\nnn\Shared” folder. Determine the location of the mofcomp file for your version using the following table as a reference:

2. Launch CMD as Administrator

3. Change the directory to the folder location from No.1

4. Example:- using Microsoft SQL server 2012 then the command will be as below

5. Then type below command and press ENTER

6. After you run the mofcomp tool, search and launch “Services”

7. Right-click on “Windows Management Instrumentation” and select “Restart”

8. If above steps do not work for you

9. Re-install new Microsoft SQL Server 2012 Express

10 Refer to https://support.qne.com.my/support/solutions/articles/81000384679-how-to-install-sql-server-2012-express

 

 

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article