Where is SQL Server Configuration Manager?

Some time you may need to use SQL Server Configuration Manager to manage and change the default settings of protocols and services used by SQL Server. But, finding the configuration manager is not as easy like management studio. Configuration manager not an application. Instead, it is a Microsoft Management Console (mmc.exe) snap-in. Follow these steps to launch and use SQL Server Configuration Manager.

Video

Steps to open SQL Server Configuration Manager

  1. Open Microsoft Management Console (mmc) by typing in “mmc.exe” in start menu. The management console will be launched.
    SQL Server Configuration Manager 1
  2. In management console, go to File menu >> Add/Remove Snap-in….
    SQL Server Configuration Manager 2
  3. In the Add or Remove Snap-ins popup window, under Available snap-ins, look for SQL Server Configuration manager, select it and press Add> button to add the snap-in to the Console Root. Finally press the OK button.
    SQL Server Configuration Manager 3
  4. SQL Server Configuration Manager is now snapped in to the left panel of the MMC. You can now expand the node and see the various SQL Server services and tools for configuration.
    SQL Server Configuration Manager 4
  5. To save the selected management console snap-in, go to the menu File >> Save.
  6. In the Save As dialog, Select the folder (may be the desktop..) you want to save the .mmc file and give a name to the file. Finally press Save button.
    SQL Server Configuration Manager 5
  7. Next time when you want to open the configuration manager, you can just double-click the saved .mmc file to open the MMC console along with the snapped in SQL Server Configuration Manager.

Read about another method of opening Configuration Manager in Windows 8.

Reference


7 thoughts on “Where is SQL Server Configuration Manager?”

    • Hi,

      Please check if “SQL Server Configuration Manager” is installed. You can check it by making sure the “SQLServerManager.msc” file in C:\Windows\SysWOW64\ or C:\Windows\System32 folder. For example, msc file for SQL Server 2019 is SQLServerManager15.msc, SQL Server 2017 is SQLServerManager14.msc. If the file is not found, then SQL Server installation was not proper.

      Reply

Leave your thoughts...

This site uses Akismet to reduce spam. Learn how your comment data is processed.