SQL 2016 Hosting – How to fix cannot connect to WMI provider in MS SQL
When you try to open SQL Configuration Manager Option and if you get an error like
“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 later servers with SQL Server Configuration Manager.”
Invalid class [0x8004100] then what will be cause? And what is the resolution?
This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server. The 32-bit instance and the 64-bit instance of SQL Server share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.
It seems the sqlmgmproviderxpsp2up.mof was damaged during the issues with the SAN.
So what is the Solution for this?
In my case I am using SQL 2012 SP1. So where can I find the sqlmgmproviderxpsp2up.mof file?
The location as follows :
C:\Program Files <x86>\Microsoft SQL Server\110\Shared folder.
The work around for this problem, you have to open a command prompt, type the following command, and then press ENTER:
Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.
The value of number depends on the version of SQL Server:nnn
Microsoft SQL Server 2012 >> 110
Microsoft SQL Server 2008 R2 >> 100
Microsoft SQL Server 2008 >> 100
Microsoft SQL Server 2005 >> 90
After you run the Mofcomp tool, make sure to restart the WMI service for the changes to take effect.
Once this is done you will be able to open the SQL Configuration Manager Console.
Best SQL 2016 Hosting Recommendation
ASPHostPortal.com provides its customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. ASPHostPortal.com offers SQL 2014 hosting starts from $5. We also guarantees 30 days money back and guarantee 99.9% uptime. If you need a reliable affordable SQL 2014 Hosting, we should be your best choice.