Sunday, 31 May 2015

WMI Error

SQL Server Configuration Manager – Cannot connect to WMI provider – Provider load failure [0x80041013]


As soon as he was trying to launch SQL Server Configuration Manager, he was seeing below error.

This problem occurs when we have installed both 32 bit version and 64 bit version of SQL Server on same Windows Machine and when we uninstall an instance of SQL Server,  WMI provider is also removed.The 32-bit instance and the 64-bit instance of SQL Server share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.
To Resolve this issue, we need to locate the file “Sqlmgmproviderxpsp2up.mof” which is present at the
"%programfiles(x86)%\Microsoft SQL Server\number\Shared folder"

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
hen, from Command Prompt we need to run below command.
mofcomp “%programfiles(x86)%\Microsoft SQLServer\number\Shared\sqlmgmproviderxpsp2up.mof”




No comments:

Post a Comment