[SQL Server] Where is my SQL Server Configuration Manager and SSMS?

 [SQL Server] Where is my SQL Server Configuration Manager and Where is my SSMS(SQL Server Management Studio)?

SQL Server Configuration Manager

Sometimes, for some reason, you can't find(search) SQL Server Configuration Manager.

Here are the file names for SQL Server Configuration Manager

• SQL Server 2022: SQLServerManager16.msc
• SQL Server 2019: SQLServerManager15.msc
• SQL Server 2017: SQLServerManager14.msc
• SQL Server 2016: SQLServerManager13.msc
• SQL Server 2014 (12.x): SQLServerManager12.msc
• SQL Server 2012 (11.x): SQLServerManager11.msc

Path

C:\Windows\SysWOW64

or

C:\Windows\System32

However they are all from System Path, therefore you can simply execute them by type it.

i.e.

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver16

=============================================================

SQL Server Management Studio

Sometimes, for some reason, you can't find(search) SQL Server Management Studio.

Here are the locations for SSMS (depending on SQL Server/SSMS versions)

From SSMS 18: The location has been changed.

• C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe

SQL Server 2017

• C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe

SQL Server 2016

• C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe

SQL Server 2014

• C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe

SQL Server 2005: Really? Do you still use SQL Server 2005?

• C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe