Sql-server – Kerberos Configuration Manager – Does it work with SQL Server 2016

I did the upgrade on my laptop with SQL Server 2008 R2 and SQL Server 2012 already installed. The issue I had was that SSCM actually disappeared from the Start Menu, if after repair it would not put them back. I ended up finding them under the Windows root directory, but have since done a complete reinstall of Windows 10 on my laptop, and reinstalled SQL Server.

I would expect you are looking at a similar situation that is going to require a reload of Windows 10. You might try just doing the refresh, where it does not completely remove everything...but I doubt that is going to work. I did a factory reset where I went back to Windows 8.1, then forced an upgrade to Windows 10. Which I might add, doing that seemed to have improved Windows 10 at least on my laptop (Lenovo Y 40-80) compared to running it after the upgrade.

One last chance you might attempt is to install the SSMS preview (standalone of SSMS) from here.

Posting this up in case anyone else sees this and runs into the same perceived issue as I had. We have SQL Server 2016 SP1 x64 installed and SSMS 2017 installed. When I open SQL Server 2017 Configuration manager, I can't see all of the items (just as you couldn't). However, when I open SQL Server 2016 Configuration Manager I can see all of the items as expected.

Some more details are here: http://internationaldatascience.com/sql-server-2016-configuration-manager-missing-ssms-17-2-cannot-connect-to-wmi-provider/

Here's the relevant info incase that blog goes down:

However, “SQL Server Network Configuration” was missing! The “SQL Server Network Configuration (32bit)” section was there, but blank as usual. Searching the web wasn’t turning up much, so I started poking around on the local machine to find the old tool. Looking on a machine that had 2016 but not the problem, I could see that the command in the Shortcut on the Start Menu for SQL Server Configuration Manager is actually a call to open a Microsoft Management Console (MMC):

C:\Windows\SysWOW64\mmc.exe /32

C:\Windows\SysWOW64\SQLServerManager13.msc I copied the “SQL Server 2016 Configuration Manager” shortcut file in the folder

“C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2016\Configuration Tools” from the donor machine to the one I was having the problem with.