June Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – SQL Server Configuration Manager Missing from Start Menu

Pinal Dave
SQL Tips and Tricks
11 Comments

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.

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

11 Comments. Leave new

Leave a Reply

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 13 SQL Server database books and 40 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline.

Exclusive Newsletter

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.




Menu
Exit mobile version