Where do I find SQL Server Management Studio?

Find the executable for SSMS.

Michael Otey

July 28, 2015

1 Min Read
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

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like