Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"
To work around this problem, open a command prompt, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"
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, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.
Source:
No Comments
You must log on to comment.