Error saat membuka SQL Server Configuration Manager : Cannot connect to WMI provider. You do not have permission or the server unreachable. Note that you can only manage SQL Server 2005 and later server with SQL Server Configuration Manager. Invalid Class.

Error saat membuka SQL Server Configuration Manager : Cannot connect to WMI provider. You do not have permission or the server unreachable. Note that you can only manage SQL Server 2005 and later server with SQL Server Configuration Manager. Invalid Class.

Pada waktu saya mau membuka SQL Server Configuration Manager, dengan cara klik ( Start -> All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager ) , tampil error sebagai berikut :

Penyelesaian :

1.       Search file mofcomp.exe ada di folder apa. Saya mendapatkannya di folder C:Windows\System32\wbem.

2.       Search file sqlmgmproviderxpsp2up.mof ada di folder apa. Saya memperolehnya di folder C:Program Files\Microsoft SQL Server\100\Shared.

3.       Ketik perintah ini di Command Prompt,  mofcomp “C: Program Files\Microsoft SQL Server\100\Shared\ sqlmgmproviderxpsp2up.mof” . ( Sesuaikan dengan nama folder di komputer anda ).

4.       Untuk memperjelas poin 3, lihat gambar di bawah ini :

5.       Masalah selesai, bukalah SQL Server Configuration Manager.

Referensi :

-          http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4c8ca86c-105f-4f0a-ac18-6e33dda2bc46/sql-server-configuration-manager-cannot-connect-to-wmi-provider-invalid-class-0x80041010?forum=sqlkjmanageability

-          http://support.microsoft.com/kb/956013