what is the reason for this error.How to solve this error?

The "WMI provider error: Access is denied. [0x80070005]" in SQL Server indicates that there is a problem with the Windows Management Instrumentation (WMI) provider, and the user account executing the query or operation does not have sufficient permissions to access or perform the requested action.

To solve this error, you can try the following steps:

Run SQL Server Management Studio (SSMS) as an administrator: Right-click on the SSMS shortcut and select "Run as administrator." This ensures that SSMS has elevated privileges.
Grant necessary permissions to the user account: Make sure the user account executing the query or operation has appropriate permissions. Grant the necessary privileges by following these steps:
- Go to "Control Panel" -> "Administrative Tools" -> "Computer Management."
- Expand "Services and Applications" -> "WMI Control."
- Right-click on "WMI Control" and select "Properties."
- In the "Security" tab, select "Root" and click the "Security" button.
- Add the user account or group and provide the necessary permissions (e.g., "Enable Account" and "Remote Enable").
Verify WMI service configuration: Ensure that the WMI service is running and properly configured. To check this:
- Open the "Services" console by typing "services.msc" in the "Run" dialog or searching in the Start menu.
- Locate the "Windows Management Instrumentation" service and make sure it is running. If not, start the service.
- Right-click on the service, select "Properties," and ensure that it is set to start automatically.
Check firewall and antivirus settings: Sometimes, the error can be caused by firewall or antivirus software blocking the WMI communication. Temporarily disable the firewall or adjust its settings to allow WMI traffic. Similarly, check the antivirus settings and create exclusions if necessary.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty3y ago
The "WMI provider error: Access is denied. [0x80070005]" in SQL Server indicates that there is a problem with the Windows Management Instrumentation (WMI) provider, and the user account executing the query or operation does not have sufficient permissions to access or perform the requested action.

To solve this error, you can try the following steps:
1. Run SQL Server Management Studio (SSMS) as an administrator: Right-click on the SSMS shortcut and select "Run as administrator." This ensures that SSMS has elevated privileges.
2. Grant necessary permissions to the user account: Make sure the user account executing the query or operation has appropriate permissions. Grant the necessary privileges by following these steps:
  
  Go to "Control Panel" -> "Administrative Tools" -> "Computer Management."
  
  Expand "Services and Applications" -> "WMI Control."
  
  Right-click on "WMI Control" and select "Properties."
  
  In the "Security" tab, select "Root" and click the "Security" button.
  
  Add the user account or group and provide the necessary permissions (e.g., "Enable Account" and "Remote Enable").
3. Verify WMI service configuration: Ensure that the WMI service is running and properly configured. To check this:
  
  Open the "Services" console by typing "services.msc" in the "Run" dialog or searching in the Start menu.
  
  Locate the "Windows Management Instrumentation" service and make sure it is running. If not, start the service.
  
  Right-click on the service, select "Properties," and ensure that it is set to start automatically.
4. Check firewall and antivirus settings: Sometimes, the error can be caused by firewall or antivirus software blocking the WMI communication. Temporarily disable the firewall or adjust its settings to allow WMI traffic. Similarly, check the antivirus settings and create exclusions if necessary.
0