Friday, May 22, 2015

SQL Server 2005/2008/R2/2012: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Invalid class[0x80041010]



“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 the SQL Server Configuration Manger.
Invalid class[0x80041010]”

               

Saw this message when I tried to open SQL Server Configuration manager. With a quick search on Google led me to this website.

http://tritoneco.com/2014/05/15/fix-sql-configuration-manager-cannot-connect-to-wmi-provider/

So ran the following command and that fixed the problem.

cd "C:\Program Files (x86)\Microsoft SQL Server\110\Shared\mofcomp sqlmgmproviderxpsp2up.mof"

You can search the location of the file sqlmgmproviderxpsp2up.mof based on what version of SQL Server is installed.

My guess is that this was due to the fact that I had both SQL Server 2008 R2 and 2012 installed. But that is just speculation.


No comments:

Post a Comment