Problem:
I am getting this error message - "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 class [0x80041010]" when trying to launch SQL Server
Configuration Manager.
Had an instance been uninstalled? (Not necessarily the one you are
connecting too)? If so, the workaround is mentioned below.
Workaround:
To work around this problem, open a command prompt, type the following
command, and then press ENTER:
mofcomp
"%programfiles(x86)%\Microsoft SQL
Server\number\Shared\sqlmgmproviderxpsp2up.mof"
Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof
file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared
folder.
For executing the command make sure that you have to log in as an
administrator.
The value of number depends on the version of SQL
Server: nnn
Microsoft SQL Server 2012
|
110
|
Microsoft SQL Server 2008 R2
|
100
|
Microsoft SQL Server 2008
|
100
|
Microsoft SQL Server 2005
|
90
|
After you run the Mofcomp tool, restart the WMI service for the changes
to take effect. The service name is Windows management Instrumentation.
Warm Regards,
Chhavinath
Mishra
Sr. Specialist Database Administrator
Sr. Specialist Database Administrator
MCITP
No comments:
Post a Comment