269

After installing SQL Server 2008, I cannot find the SQL Server Configuration Manager in Start / SQL Server 2008 / Configuration Tools menu.

What should I do to install this tool?

Improve this question
4
  • 25
    I have this tool on my machine and shortcut with target C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager10.msc. Do you have such *.msc file on your computer?
    – alex.b
    Commented Mar 23, 2012 at 18:51
  • Yes, I have both these files on my computer. When running SQLServerManager10.msc, it showed the following message: MMC could not create the snap-in. The snap-in might not have been installed correctly. Name: SQL Server Configuration Manager CLID: {D52E5F54-75D9-4A93-91B7-2215EA5CBED2}
    – Jin Ho
    Commented Mar 24, 2012 at 13:22
  • 2
    Select repair option can fix the problem.
    – Jin Ho
    Commented Mar 24, 2012 at 13:44
  • superuser.com/a/1002999/2115
    – Click Ok
    Commented Apr 26, 2017 at 20:18

14 Answers 14

Reset to default
547

If you happen to be using Windows 8 and up, here's how to get to it:

  • The newer Microsoft SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program.

  • It is not a stand-alone program as used in the previous versions of Microsoft Windows operating systems.

  • SQL Server Configuration Manager doesn’t appear as an application when running Windows 8.

  • To open SQL Server Configuration Manager, in the Search charm, under Apps, type:

    SQLServerManager15.msc for [SQL Server 2019] or

    SQLServerManager14.msc for [SQL Server 2017] or

    SQLServerManager13.msc for [SQL Server 2016] or

    SQLServerManager12.msc for [SQL Server 2014] or

    SQLServerManager11.msc for [SQL Server 2012] or

    SQLServerManager10.msc for [SQL Server 2008], and then press Enter.

Text kindly reproduced from SQL Server Configuration Manager changes in Windows 8

Detailed info from MSDN: SQL Server Configuration Manager

Improve this answer
13
  • 23
    Thanks Leniel. This is absolutely ridiculous. Why in the world MS saw fit to hide a commonly used application is beyond me. Just another reason for me to despise Windows 8.
    – PseudoToad
    Commented Apr 24, 2014 at 16:16
  • 5
    I hope Windows 9 put SQL Server Configuration Manager back to its rightful place.
    – Old Geezer
    Commented May 15, 2014 at 16:21
  • 2
    @OldGeezer me too! BTW, I liked your profile message about what to know/don't know/should know... :D
    – Leniel Maccaferri
    Commented May 15, 2014 at 16:24
  • 29
    Same with Windows 10. FYI for SQL Server 2014 it is SQLServerManager12.msc; obvious I know...
    – Simon1979
    Commented Sep 3, 2015 at 22:55
  • 5
    If you get an error cannot connect to wmi provider use the workaround from this article (run in cmd with admin rights!): support.microsoft.com/en-us/help/956013/…
    – Stalinko
    Commented May 24, 2018 at 4:55
171

On windows 10 Control Panel→Administrative Tools→Computer Management

Win 10 SQL configuration manager

Improve this answer
5
  • Thanks. If youre still having problems starting service - run configuration manager as administrator
    – Juozas
    Commented Jan 23, 2019 at 12:38
  • 3
    Just for the ease, you can open Computer Management by typing compmgmt.msc from run window or search panel.
    – Himanshu
    Commented Jul 27, 2019 at 7:00
  • 9
    SQL Server Configuration still not found
    – JuNas
    Commented May 9, 2020 at 6:35
  • 1
    How awsome it is, I can open it even without SQLServerManager12.msc -- which I couldn't find.
    – Zhang
    Commented May 13, 2021 at 11:27
  • I don't see it.
    – Vin Shahrdar
    Commented Mar 21, 2022 at 21:09
76

I know this is old but you can directly browse it using this paths..

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

SQL Server 2008 C:\Windows\SysWOW64\SQLServerManager10.msc

source is from ms site https://msdn.microsoft.com/en-us/library/ms174212.aspx

One can also specify %systemroot% for the path of Windows directory. For example:

SQL Server 2019: %systemroot%\SysWOW64\SQLServerManager15.msc

Improve this answer
3
  • 2
    How can it be accessed if it's not at this location?
    – thnkwthprtls
    Commented Aug 7, 2018 at 14:02
  • @thnkwthprtls, I added an example for the installation agnostic location.
    – Dan Guzman
    Commented Sep 29, 2018 at 21:12
  • 1
    The other answers didn't work for me, but this did, thanks!
    – Kevin
    Commented Sep 22, 2020 at 22:47
20

From SQL Server 2008 Setup, you have to select "Client Tools Connectivity" to install SQL Server Configuration Manager.

Improve this answer
2
  • This was installed in my instance (SQL 2014 on Windows 10) but the Configuration Manager was no where in the application list. Entering the full msc file name into the search does load it though
    – Josh Russo
    Commented May 18, 2016 at 13:36
  • 4
    A repair fixed my problem though
    – Josh Russo
    Commented May 18, 2016 at 13:43
19

This path worked for me. on a 32 bit machine.

C:\Windows\System32\mmc.exe /32 C:\Windows\system32\SQLServerManager10.msc

Improve this answer
1
  • 2
    @Slimshadddyyy: I don't agree with you. This does provide an answer ("where is the tool? I cannot find it"). It certainly was the right answer for me.
    – Lukas Eder
    Commented Apr 8, 2016 at 9:36
8

If you don't have any version of SQLServerManagerXX.msc, then you simply do not have it installed. I noticed it does not come with SQL server management studio 2019.

It's available (client-connectivity tools) in the SQL Server Express edition or SQL Server Developer edition which is good for dev/test (non-production) usage.

Improve this answer
2
  • This is what I needed. SQL Server Management Studio version 18 just doesn't come with Configuration Manager. More detail on this is available on this Super User answer: superuser.com/a/1513757/1307460
    – Richard Abey-Nesbit
    Commented Apr 18, 2021 at 22:15
  • THANK YOU this saved me
    – Benito
    Commented Oct 17, 2021 at 17:54
5

you need to identify sql version.

SQLServerManager15.msc for [SQL Server 2019] or

SQLServerManager14.msc for [SQL Server 2017] or

SQLServerManager13.msc for [SQL Server 2016] or

SQLServerManager12.msc for [SQL Server 2014] or

SQLServerManager11.msc for [SQL Server 2012] or

SQLServerManager10.msc for [SQL Server 2008],

enter image description here

Step :1) open ssms

  2) select version

  3) select above command and run in cmd with admin right.
Improve this answer
1
  • Not quite sure why the downvote ... this does show where to find it, even if it shows a complete lack of having read the question.
    – undrline - Reinstate Monica
    Commented Jun 21, 2019 at 16:56
5

For SQL Server 2017 it is : C:\Windows\SysWOW64\SQLServerManager14.msc

For SQL Server 2016 it is : C:\Windows\SysWOW64\SQLServerManager13.msc

For SQL Server 2016 it is :C:\Windows\SysWOW64\SQLServerManager12.msc

and to add it back to the start menu, copy it from the original location provided above and paste it to

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2017\Configuration Tools\

This would put back the configuration manager under start menu.

Source: How to open sql server configuration manager in windows 10?

Improve this answer
3

SQL Server Configuration Manager is located at "C:\Windows\SysWOW64\SQLServerManagerXX.msc".

So, to find it in your Windows Machine, put "C:\Windows\SysWOW64\SQLServerManager" without "XX.msc" to the search box as shown below. *I could find "C:\Windows\SysWOW64\SQLServerManager15.msc" in my Windows Machine as shown below:

enter image description here

Improve this answer
1

Paste this line in folder path url in file explore: C:\Windows\SysWOW64\SQLServerManager11.msc then press enter.

enter image description here

Improve this answer
1

Go to this location C:\Windows\System32 and find SQLServerManager . Worked for me. Configuration manager was there but somehow wasn't showing up in search results.

Improve this answer
0
0

You can also launch mmc.exe and choose the SQL Server Configuration Manager from Add Remove Snap-ins:

enter image description here

Improve this answer
0

C:\Windows\System32\SQLServerManager15.msc

The version may be different

SQLServerManager<version>.msc
Improve this answer
0

In our checklist at work forgot that you actually need to install SQL Server also, if you have a license you can download it from: https://my.visualstudio.com/

Improve this answer

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