Cannot Connect to WMI Provider. You do not have permissions of the server is unreachable
Sometime while connecting to MSSQL Server Configuration Manager it throws following Error
Cannot Connect to WMI Provider. You do not have permissions of the server is unreachable. Note that you can only manage SQL Server 2005 servers with the SQL Server Configuration Manager.
Invalid namespace[0x8004100e]
I have searched on Google and found that it happens when 32bit MSSSQL application is installed on 64bit Server and they suggested to execute the following command to fix the issue.
mofcomp "%programfiles%\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"
MOF files are appropriate for static management data or dynamic management data. Static data includes details such as the computer user’s phone number, office number, and name. Dynamic data includes details such as Microsoft SQL Server(tm) database sizes and applications installed with Windows Installer.
Thanks…
This worked like charm :)
Saved my lots of time …
You are most welcome :)