MSSQL Tutorials

SQL Server Management Studio (Ssms.exe) executable file location.

adminComments Off on SQL Server Management Studio (Ssms.exe) executable file location.

The executable file (Ssms.exe) for SQL Server Management Studio is located in different locations depending on the version of SQL Server.

For SQL Managment Studio 18 

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

For SQL Server 2017:

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

For SQL Server 2016:

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

For SQL Server 2014:

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

For SQL Server 2012:

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

For SQL Server 2008 R2:

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

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

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

Related Articles
MSSQL Tutorials

How To Find Which MS SQL Server Version You Are Using

admin

In this quick guide you will learn how to find the exact MS SQL version that you Are Running
MSSQL Tutorials

Download Previous Versions Of SQL Managment Studio

admin

In this chapter you will find release notes for SQL Server Management Studio (SSMS) and previous version download links.
MSSQL Tutorials

SQL Server Configuration Manager Location

admin

Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager does not appear as an application in newer versions of Windows.