74

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

2 Answers 2

Reset to default
112

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
4
  • 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, 2016 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, 2018 at 23:33
  • This was dumb. Why was it moved to such an obscure location? Thanks, Microsoft. :(
    – Will Strohl
    Dec 6, 2018 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, 2019 at 22:58
17

check this microsoft doc page for sql server configuration manager.
snippet (May 2021):

SQL Server 2019     C:\Windows\SysWOW64\SQLServerManager15.msc
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .