How can I start SQL Server Configuration Manager from the command-line?

SQL Server Configuration Manager is a low-level configuration utility for SQL Server. Technically, the Configuration Manager is an MMC (Microsoft Management Console) snap-in hosted by a small executable. The name changes slightly between versions, but the path is predictable.

The start the Configuration Manager from the command-line for SQL Server 2017, run:

C:\Windows\SysWOW64\mmc.exe /32 C:\Windows\SysWOW64\SQLServerManager14.msc

For older versions, the naming of the snap-in is:

• SQL Server 2016: SQLServerManager13.msc
• SQL Server 2014: SQLServerManager12.msc
• SQL Server 2012: SQLServerManager11.msc

Once the tool is open, you can start/stop services, configure network protocols, or change startup accounts. If you use it frequently, create a shortcut with the correct .msc file for your version, or add a small PowerShell alias:

Set-Alias sqlcfg "C:\Windows\SysWOW64\mmc.exe 'C:\Windows\SysWOW64\SQLServerManager14.msc'"

This is nifty when managing multiple servers or versions.