Tuesday, June 30, 2015

Cannot connect to WMI provider - SQL Server Configuration Manager



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 later servers with SQL Server Configuration Manager.”














Resolution:

Open command prompt, navigate following path:
C:\Program Files <x86>\Microsoft SQL Server\110\Shared

The value of number depends on the version of SQL Server

Microsoft SQL Server 2012
110
Microsoft SQL Server 2008 R2
100
Microsoft SQL Server 2008
100
Microsoft SQL Server 2005
90

 
Type next command, and then press ENTER:

mofcomp sqlmgmproviderxpsp2up.mof











After you run the Mofcomp tool, make sure to restart the WMI service for the changes to take effect.

No comments:

Post a Comment