SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, configure the network protocols used by SQL Server, and manage the network connectivity.

This article demonstrates how not to be fooled by the vanishing act of SQL Server Configuration Manager. Nobody likes to waste time trying to find something that should be readily.

Please see the following command to run SQL Server Configuration Manager on the machine hosting the database. Right click on Windows logo in lower left (on Task Bar)

Understanding the Context

This article talks about the SQL Server configuration manager and how we can use it to configure SQL Server services and its configuration parameters.

The SQL Configuration Manager is a useful tool for managing SQL Server instances and their configuration settings. To locate the SQL Configuration Manager, follow the steps below:

SQL Server Configuration Manager is used to start, pause, resume, or stop the services, to view service properties, or to change service properties. Step-by-step guide

SQL Server Configuration Manager (SSCM) is a vital administration console for managing local and remote SQL Server instances, their associated services, and network configurations.

Key Insights

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.

Summary: You may need to change the default configuration of your SQL Server instance, for example to allow TCP/IP access. The SQL Server Configuration Manager is not an application, it is.

SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, configure the network protocols used by SQL Server, and manage the network connectivity configuration from.