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