Posts
Few days before I had experienced issue with the WMI not able to connect as shown in the below figure.
"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 Manager. Invalid namespace[0x80041010]") when you install a 32-bit version of Microsoft SQL Server 2008 on 64-bit machine and you install an 64-bit version of SQL Server 2008 on the same machine. If you uninstall any instances you will receive the error message when you open SQL Server Configuration Manager.
When you install sql server 2008 WMI provider also gets installed and if 2005already existed on the machine then WMI provider is common for both versions, Soif you uninstall SQL Server 2008 it deletes WMI Provider. This file is located in the %programfiles(x86)% folder.
The WMI (Windows Management Instrumentation) provider is a published layer that is used with the SQL Server Configuration Manager snap-in for Microsoft Management Console (MMC) and the Microsoft SQL Server Configuration Manager. It provides a unified way for interfacing with the API calls that manage the registry operations requested by SQL Server Configuration Manager and provides enhanced control and manipulation over the selected SQL Server services. The SQL Server WMI Provider is a DLL and a MOF file, which are compiled automatically by SQL Server Setup.
The resolution is, open command prompt run as ADMINISTRATOR.
mofcomp "%programfiles(x86)%\Microsoft\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
Note: The location may be different as shown in the figure below.
"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 Manager. Invalid namespace[0x80041010]") when you install a 32-bit version of Microsoft SQL Server 2008 on 64-bit machine and you install an 64-bit version of SQL Server 2008 on the same machine. If you uninstall any instances you will receive the error message when you open SQL Server Configuration Manager.
The WMI (Windows Management Instrumentation) provider is a published layer that is used with the SQL Server Configuration Manager snap-in for Microsoft Management Console (MMC) and the Microsoft SQL Server Configuration Manager. It provides a unified way for interfacing with the API calls that manage the registry operations requested by SQL Server Configuration Manager and provides enhanced control and manipulation over the selected SQL Server services. The SQL Server WMI Provider is a DLL and a MOF file, which are compiled automatically by SQL Server Setup.
The resolution is, open command prompt run as ADMINISTRATOR.
mofcomp "%programfiles(x86)%\Microsoft\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
Note: The location may be different as shown in the figure below.
I did that and got that result and I still cannot connect to wmi provider on Windows xp pro sp3
ReplyDeletehi, i did that too and i still cannot connect to wmi provider on Windows Server 2008 R2 Standard and SQL Server 2008, any suggestion
ReplyDeletePromod, this worked just fine for me. Opened a CMD window as Administrator, navigated to the correct folder:
ReplyDeletecd \Program Files (x86)\Microsoft SQL Server\100\Shared\
I confirmed that the required .mof file was present in the folder and then executed your command:
mofcomp sqlmgmproviderxpsp2up.mof
Went back into SQL Configuration Manager and the error was gone.
Thanks!
Many thanks this fixed my issue!
ReplyDeleteDid exactly the same as told. Fixed my issue
ReplyDeleteThanks..