How to install SQL Server Management Studio (SSMS) v. 16.5
Download SSMS here: https://msdn.microsoft.com/en-us/library/mt238290.aspx
Navigate to where the downloaded file is located and double-click.
Be patient while the installation is carried out.
No user action is required for the remainder of the installation.
To open the SQL Server Management Studio (SSMS) go to Startà Run (or press Windows + R ) and enter SSMS, and click ‘OK’.
You can also locate the Microsoft SQL Server Management Studio application under the Apps menu from the desktop.
The shortcut location is found here: C:ProgramDataMicrosoftWindowsStart MenuProgramsMicrosoft SQL Server 2016, but the SSMS app .exe is found here: E:Program Files (x86)Microsoft SQL Server130ToolsBinnManagementStudioSSMS.exe
Be patient while SSMS opens for the first time.
Specify the database server name, and click ‘Connect’.
You will then see the database server object folders under the Object Explorer.
Categories: SQL Stuff