SQL Server 2017 Error accessing Local DB Engine and SQL Config Manager

0

I tried to connect to my local DB engine on SSMS 2017 and got the following error message: enter image description here

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)

enter image description here

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.

sql-server
sql-server-2017
ssms-2017
asked on Stack Overflow Oct 11, 2018 by Max S. • edited Oct 15, 2018 by Max S.

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0