I get many emails every day and I do respond to them as soon as I can. Sometimes they are about the business and sometimes they are from my blog readers who have followed my other blog and need help with something else. Most of the time, I do have a solution for them. In this blog, we would learn about how to open SQL Server Configuration Manager when there is no shortcut in start menu.
One of my blog readers sent below email.
Sorry for the direct email rather. You will not know me, but I have been taking help from you via your blogs for many years. I am sure there are many in the world who are getting benefited from the knowledge which you share via daily blogs. I would like to thank you on behalf of everyone who has been successful due to your blogs.
I wanted one assistance from you as I didn’t see any blog about the problem which I am facing as of today. I have been using SQL Server Configuration Manager to manage SQL Server related services. Today, due to some custom patching from my company, I saw that I don’t have SQL Server Configuration Manager on any of the server. I am not sure where it is gone.
Do you know how to get it back?
I did some search and found that it is a snap-in in MMC. There are multiple ways to open it. Here are the steps
- Start > Run > MMC
- It would open below. Choose File > Add/Remove Snap-in.
- Open the snap-in window opens, we should choose “SQL Server Configuration Manager” from the list and hit “Add”
- It should be in the “Selected snap-ins” as seen in the following image.
That should be it. Hit OK and you should get SQL Server Configuration Manager.
If you want a shortcut then below is the command line which would open SQL Server Configuration Manager for SQL Server 2017. You can right click and create a new shortcut with below command.
C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager14.msc
The last piece is the version of SQL Server installed on the machine. Version 14 represents, SQL Server 2017. Here is the version list as of today.
|SQL Server 2008/R2||SQLServerManager10.msc|
|SQL Server 2012||SQLServerManager11.msc|
|SQL Server 2014||SQLServerManager12.msc|
|SQL Server 2016||SQLServerManager13.msc|
|SQL Server 2017||SQLServerManager14.msc|
Have you encountered this same issue earlier? Is there any other solution? Please comment and share with others. Reference: Pinal Dave (https://blog.sqlauthority.com)
Thanks Pinal Dave,today you shared very useful tip.
On windows 10
Control Panel -> Administrative Tools -> Computer Management
right click on ‘my computer’ -> Manage -> Computer Management
under – ‘services and applications’ we can see ‘SQL Server Configuration Manager’
For SQL 2016 just running “SQLServerManager13.msc” works or make a shortcut to “C:\Windows\System32\SQLServerManager13.msc” The shell knows to use mmc when you open a .msc file
On Windows 10 I can’t find the snap in file. I’ve tried a global search to no avail. I have Sql Server Management Studio 18.3.1, Sql Server 2016, and Visual Studio Community 2019.