62

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 used to find it in Windows 8.1.  In Windows 10 there is SQL Server Management Studio but there is no configuration like there was in Windows 8.1:

Start menu application listing

| improve this question | | | | |
  • 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
94

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

| improve this answer | | | | |
  • 5
    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 '18 at 23:33
  • This was dumb. Why was it moved to such an obscure location? Thanks, Microsoft. :( – Will Strohl Dec 6 '18 at 16:03
  • Microsoft's intention is for users to access the Configuration Manager via MMC by adding a snap-in. (Start, Run, "mmc", File, Add/Remove Snap-in..) IMHO, Computer Management is easier to use if you only have one version of Configuration Manager you need to access, otherwise utilize the snap-in. – Adam Caviness Sep 11 '19 at 22:58
14

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
| improve this answer | | | | |

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