Wednesday, 22 July 2020

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

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

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

Here are the locations (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

No comments:

Post a Comment

(KOR)☁️ AWS Solutions Architect Associate 자격증 취득 여정

  !저의 경험 , 팁 , 그리고 SAA-C03 자격증 합격을 위한 노하우 공유! 조금 늦은 포스팅이지만 , 꼭 공유하고 싶었던 이야기입니다 . 회사 내 주변 동료들이 자주 이렇게 말하곤 했습니다 . “ 님 실...