Where do I find SQL Server Management Studio?

Q: One of our admins accidentally deleted the shortcut to SQL Server Management Studio (SSMS). What is the name of the SSMS executable and where can I find it?

A: The executable file for SQL Server Management Studio is found in different locations depending on the version of SQL Server that you’re using. For SQL Server 2014 and SQL Server 2012 the executable for SSMS is called ssme.exe.

For SQL Server 2014 is found in the following directory:

C:Program Files (x86)Microsoft SQL Server120ToolsBinnManagementStudioSsms.exe

For SQL Server 2012 you can find SSMS at:

C:Program Files (x86)Microsoft SQL Server110ToolsBinnManagementStudioSsms.exe

For SQL Server 2008 R2 you can find SSMS at:

C:Program FilesMicrosoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe

For the older SQL Server 2005 instances SSMS file was called SqlWb.exe and it’s located at:

C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe