I tried to connect to my local DB engine on SSMS 2017 and got the following error message:
Having gone through a series of videos and Stackoverflow, I ended up trying to open SQL Server Config Manager 2017, which gives me the following 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 servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e]" (as seen below)
I saw all the answers concerning the running from cmd prompt (admin) of the "C:\Program Files (x86)\Microsoft SQL Server\140\Shared\sqlmgmproviderxpsp2up.mof" file (see Error starting SQL Server configuration manager)
BUT! Once I run this mof file in command prompt, a pop-up appears and tells me to choose which program to open this file with... In other other words, I don't get the "Parsing MOF file: sqlmgmproviderxpsp2up.mof MOF file has been successfully parsed" message.
Any suggestions pls?
EDIT1: - I added the error screenshots. - I noticed as well the error seen in the second pic only occurs wuth the SQL Server Config Manager 2017, whereas the one 2008 R2, opens up just fine.
User contributions licensed under CC BY-SA 3.0