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"
May 28, 2015 by Anuraj
Miscellaneous SQL Server
Today while working on SQL Server configuration I faced this strange error.
I was running as administrator and I know SQL Server was running. Later I found a Microsoft KB article related to this issue. This issue is because “On a 64-bit computer, you install an instance of the 32-bit (x86-based) version of Microsoft SQL Server. On the same computer, you install an instance of the 64-bit version of SQL Server 2008. If you then uninstall the 64-bit instance, you receive the following error message when you open SQL Server Configuration Manager”
As a workaround Microsoft suggest to run the following command.
mofcomp “%programfiles(x86)%\Microsoft SQL Server[number]\Shared\sqlmgmproviderxpsp2up.mof”
Replace the number based on the version of SQL Server installed on your system.
| Microsoft SQL Server 2012 | 110 |
| Microsoft SQL Server 2008 R2 | 100 |
| Microsoft SQL Server 2008 | 100 |
| Microsoft SQL Server 2005 | 90 |
Microsoft KB article - https://support.microsoft.com/en-us/kb/956013
Happy Programming :)
Copyright © 2024 Anuraj. Blog content licensed under the Creative Commons CC BY 2.5 | Unless otherwise stated or granted, code samples licensed under the MIT license. This is a personal blog. The opinions expressed here represent my own and not those of my employer. Powered by Jekyll. Hosted with ❤ by GitHub