TDS Error SQL

Error In Spectrum - SQLServerManager10.msc >> "Cannot connect to WMI provider. You do not have permission or the server is unreachable."

If you receive the error "Cannot connect to WMI provider. You do not have permission or the server is unreachable." when attempting to launch the SQL Configuration Manager :

            cannot_connect_WMI.png 

SQL Server Configuration Manager use Window Management Instrumentation (WMI) to view and change some server settings. When connecting to servers, SQL Server Configuration Manager uses WMI to obtain the status of the SQL Server (MSSQLSERVER) and SQL Server Agent services. This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server.

Solution:
To resolve the error, you need to register the sqlmgmproviderxpsp2up.mof file on your system, to do so please follow the instructions provided here:

Step 1: 
Open  Command prompt (Run as Administrator) .

Step 2:
Type the following command here

cd.. >> Means go to Back Directory
cd C:\Program Files (x86)\Microsoft SQL Server\100\Shared >> Open this Path Directory

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"  

            



Step 3 :
In case sqlmgmproviderxpsp2up.mof is available at some other path then locate the file from that location only.
            
            

Press  Enter , it will display message  -

Microsoft (R) MOF Compiler Version 10.0.19041.1
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository...
Done!


This will help to resolve the issue
‚Äč
If the same issue occur, You need to contact your System engineer to get it resolved.

    • Related Articles

    • ERROR Of SQL Server OLEDB Provider support

      Problem :  While accessing any window application following error may occur:  SQL  Server OLEDB provider support error Unable to load SQL Server OLEDB provider resource DLL. The application cannot continue. Solution : Following the steps below may ...
    • [MYSQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'LOCALHOST' (10061)

      MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications.  KDK Software uses MySQL as its ...
    • Server Error in '/eXBace' Application.

      Server Error in '/eXBace' Application. Access to the registry key 'HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.LKey.lic.k' is denied.              Solution : Regarding this issue you are requested to please open Registry Editor (Open Run > regedit). ...
    • Run time Error 70 permission denied while opening software Spectrum\Taxsuit

      Please note due to some security concerns of Windows 7 \ Windows 8 \Windows 10,  you are not able to run the software. However, to resolve the issue please run the software using administrator account, to do so please follow the steps below: 1. Go to ...
    • Spectrum || LAN SETTING PROCEDURE

      WHAT IS LAN SETTING AND IT’S OBJECTIVE LAN (Local Area Network) setup is developed by connecting two or more than two computers with each other using a physical connection or Wi-Fi in order to share files and data overtime. As specified above, ...