Press "Enter" to skip to content

sqlserver error 0x80041010

0

Problem

When opening the SQL Server xxxx Configuration Manager you get the following error message: “Unable to connect to the WMI provider.” You do not have the required permission or the server is not accessible. that you can manage SQL Server 2005 or later with SQL Server Configuration Manager Invalid Class [0x80041010]

Erreur SQL Server 0x80041010

Cause

According to the Microsoft site would be due to a SQL Server instance uninstall, out in my case I had this problem after an installation.

Source Microsoft.

Solution

1. Open a command prompt window in Administrator.

2. Enter the following command:

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

XXX: corresponds to the version of your SQL server.

3. Restart the WMI service (PowerShell)

Restart-Service Winmgmt

 

Note : Cette erreur empêchait également la connexion de PRTG pour le monitoring de la base.

 



Related Posts


Install WSUS with a SQL Server database
Presentation Since Windows 2016 server, it is possible to install the Windows Server Update Service (WSUS) directly with a SQL Server database. In this article we will see how to proceed. Prerequisites To install WSUS with a SQL Server database you n

Optimize the space of SQL Server databases
Presentation In this tutorial I will show how to optimize the space used by databases. The optimization of the space is done in two stages: On the database: internal data optimization On files: reducing the size of the files on the disk. It is recomm

SQL Server: Set up a backup plan
Introduction In this article, I will explain how to set up a backup plan with SQL Server. In this tutorial, we will use the wizard available in SSMS to configure the database to save as well as the schedule and then we will modify the plan to indicat

Leave a Reply

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

It looks like you're using an adblocker.
We use ads to keep our content free. Please support us by turning off your adblocker.