SQL Server Configuration Manager cannot be found

Question

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?

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, Mar 23 '12 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, Mar 24 '12 at 13:22

Leniel Maccaferri · Answer 1 · 2020-10-23T11:30:35.703

535

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

edited Oct 23 '20 at 11:30

answered Feb 13 '14 at 16:21

Leniel Maccaferri

100,159
46
371
480

22

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 Apr 24 '14 at 16:16
@Gizmo: yeah... they really do some crazy stuff beyond the rational thinking. :) – Leniel Maccaferri Apr 24 '14 at 16:19
5

I hope Windows 9 put SQL Server Configuration Manager back to its rightful place. – Old Geezer May 15 '14 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 May 15 '14 at 16:24
28

Same with Windows 10. FYI for SQL Server 2014 it is `SQLServerManager12.msc`; obvious I know... – Simon1979 Sep 03 '15 at 22:55
1

WIN 10, found it in c/windows/system32/SQLServerManager but its useless, all settings are not accessible... – Vasil Valchev Oct 27 '15 at 09:28
1

Thanks alot. Wrote it in Windows 10 search bar and found it finally – sohaiby Jan 01 '16 at 16:22
1

Thank you Leniel. Just so you and the commentors know. I have two Windows 10 machines. The one shows it the other does not... – Costa Zachariou Feb 03 '16 at 13:50
As mentioned in the comments on the main post, a repair will more than likely fix the issue. It worked for me. It's found under the `Maintenance` section of the installer, as opposed to `Installation` – Josh Russo May 18 '16 at 13:54
Mine startup type is automatic but does not start on system reboot or startup. I am using win 10 and MS SQL Server 2012 – codegrid Sep 07 '16 at 07:29
1

Thanks, widows just did an update and I couldn't figure out how to start my server instance. – Maurice Jordan Mar 20 '18 at 12:27
5

If you get an error `cannot connect to wmi provider` use the workaround from this article (run in cmd with admin rights!): https://support.microsoft.com/en-us/help/956013/error-message-when-you-open-sql-server-configuration-manager-in-sql-se – Stalinko May 24 '18 at 04:55

score 169 · Answer 2 · edited Nov 27 '17 at 09:36

169

On windows 10 Control Panel→Administrative Tools→Computer Management

edited Nov 27 '17 at 09:36

Yahya Hussein

8,767
15
58
114

answered May 31 '16 at 08:49

Osama AbuSitta

3,918
4
35
51

Thanks. If youre still having problems starting service - run configuration manager as administrator – Juozas Jan 23 '19 at 12:38
3

Just for the ease, you can open Computer Management by typing `compmgmt.msc` from run window or search panel. – Himanshu Jul 27 '19 at 07:00
9

SQL Server Configuration still not found – JuNas May 09 '20 at 06:35
1

How awsome it is, I can open it even without SQLServerManager12.msc -- which I couldn't find. – Zhang May 13 '21 at 11:27
I don't see it. – Vin Shahrdar Mar 21 '22 at 21:09

score 76 · Answer 3 · edited Sep 29 '18 at 21:11

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

edited Sep 29 '18 at 21:11

Dan Guzman

43,250
3
46
71

answered Jul 16 '16 at 15:58

Joebet Mutia

866
7
4

2

How can it be accessed if it's not at this location? – thnkwthprtls Aug 07 '18 at 14:02
@thnkwthprtls, I added an example for the installation agnostic location. – Dan Guzman Sep 29 '18 at 21:12
1

The other answers didn't work for me, but this did, thanks! – Kevin Sep 22 '20 at 22:47

score 20 · Answer 4 · answered Mar 23 '12 at 18:52

20

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

answered Mar 23 '12 at 18:52

David Brabant

41,623
16
83
111

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 May 18 '16 at 13:36
4

A repair fixed my problem though – Josh Russo May 18 '16 at 13:43

score 19 · Answer 5 · answered Dec 16 '15 at 08:26

19

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

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

answered Dec 16 '15 at 08:26

Atupele4

319
2
4

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 Apr 08 '16 at 09:36

score 8 · Answer 6 · answered Jun 16 '20 at 13:59

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.

answered Jun 16 '20 at 13:59

R. van Diesen

829
8
10

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: https://superuser.com/a/1513757/1307460 – Richard Abey-Nesbit Apr 18 '21 at 22:15
THANK YOU this saved me – Benito Oct 17 '21 at 17:54

score 6 · Answer 7 · answered Sep 02 '20 at 14:48

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?

Vishe · Answer 8 · 2019-08-19T14:30:10.593

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],

Step :1) open ssms

  2) select version

  3) select above command and run in cmd with admin right.

edited Aug 19 '19 at 14:30

answered Dec 29 '18 at 15:54

Vishe

3,383
1
24
23

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 Jun 21 '19 at 16:56

score 2 · Answer 9 · edited Feb 09 '23 at 05:36

2

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:

edited Feb 09 '23 at 05:36

Henry Ecker

34,399
18
41
57

answered Aug 23 '22 at 08:56

Super Kai - Kazuya Ito

22,221
10
124
129

score 1 · Answer 10 · answered Aug 15 '18 at 06:28

1

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

answered Aug 15 '18 at 06:28

Wajid khan

842
9
18

score 1 · Answer 11 · answered Jul 27 '20 at 08:51

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.

answered Jul 27 '20 at 08:51

Ankit Mahajan

516
7
17

score 0 · Answer 12 · answered Sep 19 '21 at 17:24

0

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

answered Sep 19 '21 at 17:24

David Browne - Microsoft

80,331
6
39
67

score 0 · Answer 13 · answered Feb 21 '22 at 16:18

0

C:\Windows\System32\SQLServerManager15.msc

The version may be different

SQLServerManager<version>.msc

answered Feb 21 '22 at 16:18

David

3,488
2
21
21

SQL Server Configuration Manager cannot be found

13 Answers13

Linked

Related