SQL Server 2019 Configuration won’t connect but Management will

sql server

I have an odd situation…

I have my SQL Server 2019 database on encrypted disk (Windows 11) so this is first attached after computer started.

So in the past I would launch SQL Server Configuration Manager and stop server, then start the server. This gives error

"Connect connect to WMI Provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2006 and later servers wit SQL Server Configuration Manager. Invalid class [0x80041010]"

However… SQL Server Management Studio and my own software can connect my database… So while one might argue there isn't a problem right now, it still worries me…

Any suggestion on how to fix this issue?

Best Answer

Please go to below folder using Command Prompt

C:\Program Files (x86)\Microsoft SQL Server\150\Shared

That path may vary depending on the installation of SQL Server.

Once you are there, please execute the following command:

mofcomp sqlmgmproviderxpsp2up.mof

Verify SQL Server Configuration Manager is running fine again.

If that does not work, please consider to repair the SQL Server installation using these steps. That won't harm successfully installed components.

Related Question