77

I just have upgraded to Windows 10 and I can't find SQL Server Configuration Manager.

I have MSSQL 2008 and 2014 installed, but there is no SQL Server Configuration Manager in "All Apps" in the Start Menu.

Below is a picture of how I used to find it in Windows 8.1. In the Windows 10 Start Menu I see SQL Server Management Studio, but there is no Configuration like there was in Windows 8.1:

Start menu application listing

music2myear
  • 49,799
malakrsnaslava
  • 2,893

2 Answers2

115

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 2017, the name is SQLServerManager14.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

screenshot of "Computer Management" window

Oreo
  • 131
  • 4
Stephen Walter
  • 1,266
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
new2ios
  • 103
John Smith
  • 301