Wednesday, June 10, 2020

SQL Server Config Manager error 'Cannot connect to WMI provider'

Description: Here I have explained how to resolved SQL Config Manager error 'Cannot Connect to WMI Provider'



Procedure: 
  • Open command prompt Run As Administrator
  • Go to SQL shared configuration folder as per your SQL version
SQL 2008: C:\Program Files (x86)\Microsoft SQL Server\100\Shared\
SQL 2012: C:\Program Files (x86)\Microsoft SQL Server\110\Shared\
SQL 2014: C:\Program Files (x86)\Microsoft SQL Server\120\Shared\
SQL 2017: C:\Program Files (x86)\Microsoft SQL Server\140\Shared\

You can find more version here

# C:\WINDOWS\system32>cd "C:\Program Files (x86)\Microsoft SQL Server\140\Shared"

# C:\Program Files (x86)\Microsoft SQL Server\140\Shared>mofcomp sqlmgmproviderxpsp2up.mof"


Note: The problem occurs because the Windows Management Instrumentation (WMI) provider configuration file for manage SQL Server services is missing.so,mofcomp command repair or recreate it.

No comments:

Post a Comment