This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of a row of tilted pinwheels in the sand with the still middle one vermilion

Activity Monitor Keeps Freezing: Fix WMI and Permissions

April 8, 2020
Pinal Dave
SQL Tips and Tricks
SQL Activity Monitor, SQL Monitoring, SQL Server Security, WMI

When Activity Monitor keeps freezing, the cause can be a missing SQL permission or a missing WMI permission for the Windows account. This post tests the SQL side on SQL Server 2025, walks through the WMI security fix and explains what CIMV2 means. It also gives a query that reads the same activity without Activity Monitor.

Read More
Server exception error.

SQL SERVER – Configuration Manager Error: The Server Threw an Exception [0x80010105]

October 15, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Configuration, WMI

SQL Server Configuration Manager failed with: the server threw an exception [0x80010105]. The usual KB did not apply to Windows Server 2008. Here is the fix.

Read More
SQL Server Configuration Manager error.

SQL SERVER – SQL Server Configuration Manager Error: 0x80010108 – The Object Invoked Has Disconnected From its Clients

October 3, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Services, Starting SQL, WMI

SQL Server Configuration Manager gave error 0x80010108: The object invoked has disconnected from its clients. Here is one cause I could reproduce on demand.

Read More
SQL SERVER - Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]

SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]

October 1, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Configuration, Starting SQL, WMI

SQL Server Configuration Manager would not open on my VM: Cannot connect to WMI provider [0x80070422]. I share what caused it and how I fixed it.

Read More
SQL SERVER - WMI Error 0x80041017 - Invalid Query Using WBEMTest

SQL SERVER – WMI Error 0x80041017 – Invalid Query Using WBEMTest

August 10, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, WMI

Helping on a forum, I asked a user to test WMI with WBEMTest and it returned error 0x80041017, Invalid query. Here are the test steps and how to fix the error.

Read More
SQL SERVER - Configuration Manager - Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable

SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable

May 20, 2017
Pinal Dave
SQL Tips and Tricks
Registry, SQL Error Messages, SQL Server, Starting SQL, WMI

SQL Server Configuration Manager said: cannot connect to WMI provider, you do not have permission or the server is unreachable. Here is the fix.

Read More
A hotel back-office bell board of small numbered brackets, one bracket empty where a bell has been taken out.

SQL SERVER – Rule “Windows Management Instrumentation (WMI) Service” failed

November 24, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, Starting SQL, WMI

Upgrading a two-node cluster from SQL 2008 R2 to 2014, the rule ‘Windows Management Instrumentation (WMI) Service’ failed. Here is how we fixed it.

Read More
1 2 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com