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
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…
After that the SQL Server Configuration Manager loads succesfully
Pantelis Apostolidis is a Sr. Cloud Solutions Architect professional at Office Line SA and a recognized Microsoft Azure MVP. For the last 15 years, Pantelis has been involved to major cloud projects in Greece and abroad, helping companies to adopt and deploy cloud technologies, driving business value. He is entitled to a lot of Microsoft Expert Certifications, demonstrating his proven experience in delivering high quality solutions. He is an author, blogger and he is acting as a spokesperson for conferences, workshops and webinars. He is also an active member of several communities as a moderator in azureheads.gr and autoexec.gr. Follow him on Twitter @papostolidis.