Search This Blog

Friday, April 3, 2009

Error message when you open SQL Server Configuration Manager

Couple of times when we tried to start SQL Server Configuration Manager it fails with errors
like below

"Cannot connect to WMI provier. You do not have permission or the server is unreachable.
Note that you can only manager SQL Server 2005 servers with SQL server Configuration
Manager. Invalid class [0x80041010]"

Reason : -
The reason behind this error is Sql Server Setup had failed to register the following .MOF file:C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmprovider.mof . This sqlmgmprovider.mof should have been registered on your machine during Sql server setup.
Solution :-

We would do what Sql server setup should have done.
1. Run cmd to get command prompt.
2. Run the below command,
a) C:\ Program Files (x86)\Microsoft SQL Server\90\Shared>mofcomp "C:\ Program Files
(x86)\Microsoft SQL Server\90\Shared\sqlmgmprovider.mof"
3. If the above doesn't work you can even try to register the file sqlmgmproviderxpsp2up.mof as
below.
a) C:\ Program Files (x86)\Microsoft SQL Server\90\Shared>mofcomp "C:\ Program Files
(x86)\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

KB: 956013: Error message when you open SQL Server Configuration Manager in SQL Server
2008: "Cannot connect to WMI provider. You do not have permission or the
server is unreachable"