Thursday, 21 September 2017

Where is my SQL Server Configuration Manager?

If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications.   This is because SQL Server Configuration Manager is not a stand-alone program, and therefore doesn’t appear as an application in newer versions of Windows.   The SQL Server Configuration Manager is a Microsoft Management Console snap-in.

You can find the SQL Server Configuration Manager snap-in in the C:\Windows\SysWow64 directory, as shown below.

SQL, PL-SQL, Oracle Database
SQL Server Configuration Manager

Here I have two different versions of the SQL Server Manager snap-in on my machine.  One for SQL Server 2014 (SQLServerManager12.msc) and one SQL Server 2016 (SQLServerManager13.msc). 

All it takes to get SQL Server Configuration Manager to show up in the start menu or taskbar is to right click on the snap-in and then select “Pin to Start” or “Pin to taskbar” options, as shown below.

SQL, PL-SQL, Oracle Database
“Pin to Start” or “Pin to taskbar”

More information about the SQL Server Configuration Manager can be found on this page: