[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
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
