To repair an instance, find the installation media and select the Maintenance page and there is a Repair option.
Error message: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Invalid namespace [0x8004100e] error when trying to run sqlservermanager13.msc after upgrading to server 2019 OS
We have just upgraded a server OS from server 2012 r2 to server 2019. The server is running sql server 2016.
The Sql config manager was working before the OS upgrade, but when i try to run it now i get an error message:
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Invalid namespace [0x8004100e]
I have investigated and as per
https://learn.microsoft.com/en-us/troubleshoot/sql/tools/error-message-when-you-open-configuration-manager you can repair wmi by finding the MOF ( in %programfiles(x86)%\Microsoft SQL Server\nnn\Shared ) but its not there. The page then mentions that the sql instance might need to be repaired but does not say how.
SQL Server | Other
-
Erland Sommarskog 121.5K Reputation points MVP Volunteer Moderator
2023-08-11T21:39:30.38+00:00