SQL Server Configuration Manager Error Cannot Connect to WMI Provider

SQL Server Configuration Manager Error

Saat menjalankan SQL Server Configuration Manager muncul error sebagai berikut :

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 version with SQL Server Configuration Manager. Invalid namespace [0x8004100e]

SQL Server Configuration Manager Error.  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 version with SQL Server Configuration Manager. Invalid namespace [0x8004100e]

Penyebab

Masalah ini terjadi karena WMI Provider telah dihapus saat Anda mencopot pemasangan instance SQL Server. 32-bit instance dan 64-bit instance dari SQL Server berbagi file konfigurasi WMI yang sama. File ini terletak di folder \programfiles (x86)\.

Solusi

Untuk mengatasi masalah ini,

1. Jalankan command prompt sebagai Administrator

Klik logo windows yang berada dipojok kiri bawah, lalu ketik command. Kemudian klik kanan pada icon bertuliskan Command Prompt. Dilayar akan tampil sebagai berikut :

Lalu klik Run as administrator, sehingga akan tampil window console sebegai berikut :

Administrator Command Prompt

2. Jalankan MOFCOMP

Ketik perintah berikut, kemudian tekan ENTER:
mofcomp “% programfiles (x86)% \ Microsoft SQL Server \ nomor \ Shared \ sqlmgmproviderxpsp2up.mof”

Catatan Agar perintah ini berhasil, file Sqlmgmproviderxpsp2up.mof harus ada di folder% programfiles (x86)% \ Microsoft SQL Server \ number \ Shared.

Nilai nomor tergantung pada versi SQL Server: nnn

Microsoft SQL Server 2017 140
Microsoft SQL Server 2016 130
Microsoft SQL Server 2014 120
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90

Setelah perintah dijalankan, pada commad prompt akan terlihat tampilan sebgai berikut :

Microsoft Windows [Version 10.0.14393] (c) 2016 Microsoft Corporation. All rights reserved.  C:\WINDOWS\system32>mofcomp "C:\Program Files (x86)\Microsoft SQL Server\140\Shared\sqlmgmproviderxpsp2up.mof" Microsoft (R) MOF Compiler Version 10.0.14393.0 Copyright (c) Microsoft Corp. 1997-2006. All rights reserved. Parsing MOF file: C:\Program Files (x86)\Microsoft SQL Server\140\Shared\sqlmgmproviderxpsp2up.mof MOF file has been successfully parsed Storing data in the repository... Done!  C:\WINDOWS\system32>

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.