SQL SERVER – SQL Server Configuration Manager Missing from Start Menu

Earlier I wrote a blog on the same topic and today I found another way to do the same thing. In this blog, we would discuss the steps you can take to open SQL Server Configuration Manager when its missing from Start Menu in the Windows operating system.

Before I begin, here is my earlier blog on the same topic with one solution. How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089

Instead of searching, you can also get the file in C:\Windows\System32 folder.

SQL Server 2008 SQLServerManager10.msc
SQL Server 2012 SQLServerManager11.msc
SQL Server 2014 SQLServerManager12.msc
SQL Server 2016 SQLServerManager13.msc
SQL Server 2017 SQLServerManager14.msc
SQL Server 2019 SQLServerManager15.msc

Here is the folder and the file from my latest lab server of SQL Server 2019.

SQL SERVER - SQL Server Configuration Manager Missing from Start Menu sscm-miss-01

If you hate to open this file manually then you can create a shortcut using below steps.

  1. Open MMC.exe by going to Start > Run > mmc.exe
  2. In the menu bar, go to “File” and choose “Add/Remove Snap-in”
  3. That would open a new window and we need to look for “SQL Server Configuration Manager”. Highlight that and hit “Add”
  4. And then hit OK.

This would open the SQL Server Configuration Manager.

Another method would be to create a shortcut for the below program.

C:\Windows\SysWOW64\mmc.exe /32 C:\windows\SysWOW64\SQLServerManager15.msc

You need to change the highlighted name based on the version of SQL Server.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Registry, SQL Server, SQL Server Configuration, Starting SQL, Windows
Previous Post
SQL SERVER – How to Invoke SSMS Help From Command Prompt?
Next Post
SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?

Related Posts

13 Comments. Leave new

Leave a ReplyCancel reply

Exit mobile version