Where is the SQL Configuration Manager in SQL Server Management Studio 18?

windows-10 sql-server ssms

5,163

The SQL Server Configuration Manager is part of SQL Server so in order to utilize it to manage the SQL Server protocols and such, you first need to install SQL Server as far as I know because it's part of and installed with the SQL Server instance installation procedure.

However, SQL Server Management Studio is a client tool which you can install onto a client which does not have any SQL Server instances running and use it to connect to and manage remote SQL Server instances.

Supporting Resources

Additionally

To get the SQL Configuration Manager 2019, you'll need to download and run the developer edition, select "New SQL Server Stand-alone installation or add features to an existing installation" from the setup menu and then in the feature selection, select. . .

Shared Features => Client Tools Connectivity

Also consider selecting. . .

Shared Features => Client Tools Backwards Compatibility

Once that install completes, you should be able to find SQLServerManager15.msc file at C:\Windows\SysWOW64 and access the SQL Server Configuration Manager to configure server aliases, etc.

5,163

Reboog711

Jeffry Houser is a technical entrepreneur that likes to share cool stuff with other people. Here are a few of his projects: Learn With: A series of books that teach about integrating Angular with different server side technologies by creating an application in detail. JeffryHouser.com: Jeffry's personal blog, which he writes a weekly post on technical topics. Sound Forge Scripts: I wrote some Sound Forge scripts to help convert long audio files to flac or mp3 format. Life After Flex: A training course to teach Flex Developers about AngularJS and other HTML5 technologies Jeffry has spoken at user groups and conferences all over the US, is author of multiple programming books, blogs weekly, and has written over 30 articles. He'll be more than willing to consult on your next project with you, or offer one to one mentoring in Angular, NodeJS. Drop Jeffry an email to discuss In his spare time Jeffry is a musician, old school adventure game aficionado, recording engineer, and he owns a Wii.

Updated on September 18, 2022

Comments

Reboog711 over 1 year

I am setting up a new computer, a Surface Laptop 3. I have installed SQL Server Management Studio 18.4, downloading it from here.

I am just trying to install client tools and not the server software.

In past versions I believe this install has given me a file at C:\Windows\SysWOW64SQLServerManager*.msc where the asterisk is a number, depending upon which version I installed. More info about this file in this question.

However, that file was not installed on the machine and I cannot find any way to open the configuration manager. I attempted to copy the file, 'SQLServerManager14.msc' over from another machine, but that got an error trying to open "MMC could not create the snap-in".

This might be because I have version 14, but the current version I need is 15, but that is just speculation.

If I download the full developer edition of SQL Server and try to install only the client tools, I get redirected to the download above.

Internet searching on this one seems to send me in a loop with lots of outdated info, and most people think the above link should also install the control panel plugin.

Any ideas where I can go to install the SQL Server Config Manager?
Reboog711 over 4 years

I got it figured it out; you were right I needed to step through the SQL Server install. This tool no longer comes with the client. I updated the answer w/ a screenshot and marked it as complete. Thank You!