SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?

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.

Hi Pinal,
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.

Solarwinds

Do you know how to get it back?

Thanks.

WORKAROUND/SOLUTION

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

  1. Start > Run > MMC
  2. It would open below. Choose File > Add/Remove Snap-in.
    SQL SERVER - Unable to See SQL Server Configuration Manager. How to Open it? mmc-snapin-01
  3. Open the snap-in window opens, we should choose “SQL Server Configuration Manager” from the list and hit “Add”
    SQL SERVER - Unable to See SQL Server Configuration Manager. How to Open it? mmc-snapin-02
  4. It should be in the “Selected snap-ins” as seen in the following image.
    SQL SERVER - Unable to See SQL Server Configuration Manager. How to Open it? mmc-snapin-03

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/R2SQLServerManager10.msc
SQL Server 2012SQLServerManager11.msc
SQL Server 2014SQLServerManager12.msc
SQL Server 2016SQLServerManager13.msc
SQL Server 2017SQLServerManager14.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)

Solarwinds
, , ,
Previous Post
SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client Was Not Authenticated. The Server Response Was: 5.5.1 – Using Gmail
Next Post
SQL SERVER – Backup to Microsoft Azure Tool – ERROR: Account Verification Failed

Related Posts

4 Comments. Leave new

  • Thanks Pinal Dave,today you shared very useful tip.

    Reply
  • Sanjay Monpara
    July 5, 2018 1:08 pm

    On windows 10
    Control Panel -> Administrative Tools -> Computer Management
    OR
    right click on ‘my computer’ -> Manage -> Computer Management

    under – ‘services and applications’ we can see ‘SQL Server Configuration Manager’

    Reply
  • 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

    Reply
  • Andrew Fairley
    October 16, 2019 5:12 am

    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.
    Any ideas?

    Reply

Leave a Reply

Menu