Where is SQL Configuration Manager in Windows 10?

59

7

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

malakrsnaslava

Posted 2015-11-08T10:07:00.470

Reputation: 2 533

Did you try using Windows' Search? Have you attempted a repair install of SQL? – Ƭᴇcʜιᴇ007 – 2015-11-08T16:19:51.513

I have tried with windows search, but I didnt try to repait installation. – malakrsnaslava – 2015-11-09T00:51:49.573

Here's a detailed answer: http://stackoverflow.com/a/21759718/290343

– Ofer Zelig – 2016-09-11T04:23:22.690

I found it in: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2014\Configuration Tools – Mariusz – 2017-07-03T12:56:04.893

Answers

92

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

Stephen Walter

Posted 2015-11-08T10:07:00.470

Reputation: 1 036

5In 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 – 2016-07-21T16:43:23.403

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 – 2018-01-11T23:33:23.017

This was dumb. Why was it moved to such an obscure location? Thanks, Microsoft. :( – Will Strohl – 2018-12-06T16:03:55.530

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 – 2019-09-11T22:58:50.953

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

John Smith

Posted 2015-11-08T10:07:00.470

Reputation: 251