SQL Server Configuration Manager Cannot Connect to WMI Provider

Today I came across a strange error. Suddenly the SQL Server Configuration Manager failed to open with the following error:

Cannot connect to WMI provider. You do not have permission or the server is unreachable Note that you can only manage SQL Server 2005 and lager servers with SQL Server Configuration Manger. Invalid class [0x80041014]

guess what, my SQL Server is 2012 SP1. Searching the web I came across several results saying that you need to run the sqlmgmproviderxpsp2up.mof

This can be done by following the below steps:

1. Open the command prompt (elevated)
2. Browse to the shared directory of your SQL server version. Even if you have 64 bit SQL installation the file is located at the “Program Files (x86)” folder. e.g. for SQL Server 2012 it is: C:Program Files (x86)Microsoft SQL Server110Shared>
3. run:  mofcomp sqlmgmproviderxpsp2up.mof

The result:
C:Program Files (x86)Microsoft SQL Server110Shared>mofcomp sqlmgmproviderxpsp2up.mof
Microsoft (R) MOF Compiler Version 6.3.9600.16384
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository…
Done!

After that the SQL Server Configuration Manager loads succesfully

Share

Leave a Reply

Your email address will not be published.

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