I just have upgraded to windows 10. I can't find sql server configuration manager. I have MSSQL 2008 and 2014 installed but there is no configuration manager in All Apps.

This is just a picture of how I use to find it in windows 8.1, in windows 10 there is Sql Server Managment Studio but there is no configuration like there was in windows 8.1 enter image description here

  • Did you try using Windows' Search? Have you attempted a repair install of SQL? – Ƭᴇcʜιᴇ007 Nov 8 '15 at 16:19
  • I have tried with windows search, but I didnt try to repait installation. – malakrsnaslava Nov 9 '15 at 0:51
  • Here's a detailed answer: stackoverflow.com/a/21759718/290343 – Ofer Zelig Sep 11 '16 at 4:23
  • I found it in: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2014\Configuration Tools – Mariusz Jul 3 '17 at 12:56
up vote 62 down vote accepted

In later versions of SQL Server, the configuration manager is implemented as an MMC plugin.

There are two ways of accessing this:

  1. Navigate to c:\windows\system32 and look for a file with the name SQLServerManagernn.msc, where nn is the version of SQL Server you have installed. For SQLServer 2014, the name is SQLServerManager12.msc. You can double-click on it and you'll see a result. You can also make a shortcut on the desktop if you like.
  2. A much simpler way is to run the Computer Management applet from Control Panel→Administrative Tools→Computer Management, where you should find the configuration manager installed

  • 4
    In my Win10 machine I had to do: Right_Click on Windows Icon-->Control Panel-->System and Security-->Administrative Tools-->Computer Management-->SQL Server Configuration Manager – nam Jul 21 '16 at 16:43
  • Be prepared to find 2 identical managers in the tree. One is for the latest, another is for one of the old versions. And it is no longer possible to change startup type. Thank you Microsoft for another drastic change in UI behavior! I hope that bad karma catches up with your execs soon. – ajeh Jan 11 at 23:33

check this microsoft doc page for sql server configuration manager.
snippet (Feb 2018):

SQL Server 2017     C:\Windows\SysWOW64\SQLServerManager14.msc
SQL Server 2016     C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014     C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012     C:\Windows\SysWOW64\SQLServerManager11.msc

protected by Community May 20 at 6:39

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.